admin

I use a lot of arrays in my procedures and l use this procedure from Chip Pearson to check if the array is empty. IMO …

Is array empty Read More »

I use a lot of arrays in my procedures and l use this procedure from Chip Pearson to check if the array has been allocated. …

Is array allocated Read More »

I have been using this procedure for many years.Easily converts worksheet formula to vba syntaxOutputs result clipboard and immediate windowHow to use; select cell containing …

Convert worksheet formula to string that can be used in vba Read More »

Cleans up date’s entered as string values in a given rangeAuthor: michael@excelexperts.co.uk

This is the procedure l have used for many years to reverse the speed up macro execution time procedure.This can be edited to suit your …

Speed up macro execution time – restoring Read More »

This is the procedure l have used for many years to speed up macro execution time.This can be edited to suit your requirement by simply …

Speed up macro execution time Read More »

Function to extract unique values from a given range.Uses the vba ‘Dictionary’ and returns a dictionary.The dictionary method has several benefits over the collectionmethod and …

Extract uniques values from a range (Dictionary method) Read More »

Function to extract unique values from a given range.Uses the vba ‘Collection’ and returns a collection.Please see the included procedure ‘HowToUse_GetUniquesFromRange_Coll’Author: michael@excelexperts.co.uk

Function to determine if a string includes a number.Returns boolean value.Author: michael@excelexperts.co.uk

Procedure that deletes pecificrows in bulkAccepts the following parmeters:Sought valueRange to evaluatesEquals; True or FalseAuthor: michael@excelexperts.co.uk