Is array empty
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
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
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
Clean up date’s entered as string values Read More »
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
Extract uniques values from a range (Collection method) Read More »
Function to determine if a string includes a number.Returns boolean value.Author: michael@excelexperts.co.uk
Does the string include a number Read More »
Procedure that deletes pecificrows in bulkAccepts the following parmeters:Sought valueRange to evaluatesEquals; True or FalseAuthor: michael@excelexperts.co.uk
Delete specific rows – in bulk Read More »