Search results 35

  2. Search results
  3. worksheet
Sorted from new to old.
Card image
Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3
Card image
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1
Card image
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9
Card image
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23
Card image
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9
Card image
CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9
Card image
ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8
Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9
Card image
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9
Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7
Card image
Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7
Card image
RowsCount

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

2018Jun22
Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17
Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16
Card image
Match3

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

2018Jun16
Card image
Match2

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

2018Jun16
123