VBA - My CMS

List of VBA Code Examples

Some of my code examples may reference public variables that l use as part of my code library.
Other examples may include error trapping techniques.
Please refer to these posts for details:

Public Variables

Starting a new VBA procedure

New VBA procedure; error message

Is array empty

Is array allocated

Convert worksheet formula to string that can be used in vba

Clean up date’s entered as string values

Speed up macro execution time – restoring

Speed up macro execution time

Extract uniques values from a range (Dictionary method)

Extract uniques values from a range (Collection method)

Does the string include a number

Delete specific rows – in bulk

Convert column alpha to numeric

Convert column numeric to alpha

Search for specific header column

Concatenate all values in a range

Path exists on network?

File exists on network?

Return date of the last save.

Delete all pictures

Make all named ranges visible

Delete all shapes

Delete all custom styles

Display status bar message

Worksheet exists ?

Is worksheet empty

Apply filters to specific range

Remove filters from all worksheets

Return the current user username

Return the current user login ID

Is workbook open in current Excel instance

Is workbook open anywhere on network

Return filename only

Select a file

Select a folder

Leftmost worksheet in view

Get the last column

Get the last row

List of VBA Code Examples

Quick Links

Contact us

Address