Search results 87

  2. Search results
  3. book
Card image cap
CellHyperlink_ToSheet

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

2018Jun24
Card image cap
LogSheet_Add + LogSheet_Clear

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

2018Jun24
Card image cap
RowsCount

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

2018Jun22
Card image cap
CanAccessVBA

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

2018Jun22
Card image cap
CellRead

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

2018Jun16
Card image cap
Match2

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

2018Jun16
Card image cap
WorkbookOpen_ANmar

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

2018Jun16
Card image cap
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image cap
DeleteAllShapes

Delete all shapes in a sheet

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

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

2018Jun11
Card image cap
FindName

Finds a name in a workbook, returns true or false

2018Jun10
Card image cap
FindSheet

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

2018Jun7