Search results 46

Sorted from new to old.

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

2018Aug9

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

2018Aug8

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

2018Jul9

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

2018Jul9

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

2018Jul7

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

2018Jul7

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

2018Jun22

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

2018Jun17

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

2018Jun16

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

2018Jun16

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

2018Jun16

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

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

2018May23