Search results 179

Sorted from new to old.

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

FGColor_Calc

To set the color of the foreground based on background color to get best look. ...

2018Jun20

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Container Switcher

Using Classic ASP and cookies, allow users to personally choose between normal ...

2018Jun10

FindName

Finds a name in a workbook, returns true or false

2018Jun10

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

1 2 ...11 12