Search results 115

Card image cap
SheetTabColor

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

Card image cap
Arr_1Dim_2Str

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

Card image cap
Refresh Table from View

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

Card image cap
FrmRename

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

frmRename.zip

Card image cap
Excel user name

Get application user name or change it Originally from

Card image cap
ArrSort_4Arr

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

Card image cap
ImportCSVs - 1st AI Code

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

Card image cap
Convert_Dash_to_Zero

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

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Card image cap
UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

Card image cap
MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...