Search results 172

Sorted from new to old.
Card image
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Card image
ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

Card image
AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

Card image
Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

Card image
SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image
Modal form open Workbook

Do not open workbook from userform after .show

Card image
IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

Card image
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image
FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

Card image
Excel user name

Get application user name or change it Originally from

Card image
ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

Card image
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

Card image
AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

Card image
ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...