Search results 57

Sorted from new to old.

SheetAdd_ANmar

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

2019Apr1

User-Defined Formatting

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

2019Jan9

UnMappath

Returns the virtual path of the absolute path specified in the required ...

2018Aug26

SheetName

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

2018Aug23

SheetDelete_ANmar

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

2018Aug9

CellSave_Hyperlink

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

2018Aug9

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

ExportSheets_to_1PDF

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

2018Aug8

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

Shapes-Macros

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

2018Jul9

WelcomeSheet

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

2018Jul9

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

FixENTERS_File

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

2018Jul7

Import_CSV

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

2018Jul7

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

RowsCount

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

2018Jun22

1 2 3 4