Question Determine which cells are currency in Excel


New member
Oct 24, 2019
Programming Experience
Hello all, I am very new to and am looking at writing some code that will seek out all currency cells in an excel workbook and replace the number formatting with a new currency symbol.

In VBA i use VARTYPE(cell address) and it would return a 6 if it is a currency cell. When i try doing the same in i get 'object' returned every time (as my xlRng variable is set as an Excel.Range). I understand why it's doing this but i cant work out how to determine whether the excel range is currency or not.

Is this even possible? Any advice would be sincerely appreciated. I apologise if this is a stupid question!

Many thanks.
Top Bottom