Macro to change cell format doesn't run

So I tried to build a macro using Record that changes selected cells format to: _-* #,##0.00_-;(#,##0.00);_-* " - "??_-;_-@_-
This is essentially the standard 'accounting' format without symbol that excel has, but with parenthesis instead of a minus symbol for negative numbers.

However the macro returns a Run-time error 13 saying Type mismatch. And it's paused at the very first line of code. My code is below - any ideas?

Please Login or Register  to view this content.

Hi !

As ActiveCells does not exist in VBA (only one cell can be active !), just check in VBA inner help …

Hi Marc,

I changed it to "ActiveCell.NumberFormat" and it still kicks off.