Search results 113

  2. Search results
  3. kb
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
ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17
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
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11
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