Search results 178

  2. Search results
  3. ok
Sorted from new to old.
Card image
CellHyperlink_ToSheet

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

2018Jun24
Card image
LogSheet_Add + LogSheet_Clear

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

2018Jun24
Card image
RowsCount

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

2018Jun22
Card image
CanAccessVBA

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

2018Jun22
Card image
FGColor_Calc

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

2018Jun20
Card image
CellRead

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

2018Jun16
Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16
Card image
WorkbookOpen_ANmar

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

2018Jun16
Card image
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image
DeleteAllShapes

Delete all shapes in a sheet

2018Jun11
Card image
FixPath, IsThere, IsThere1 ...

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

2018Jun11
Card image
Container Switcher

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

2018Jun10
Card image
FindName

Finds a name in a workbook, returns true or false

2018Jun10
Card image
FindSheet

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

2018Jun7
Card image
CountColumnCells + CountColumnCells_Criteria

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

2018May23
Card image
GoToInternet

Opens webpage from within Excel, using default browser

2018May22
12...1112