Hey guys,
I've been working with a macro, that used to work perfectly for me, but now somehow the selection function is completely messed up, I used to use this macro for a few months, but now it is somehow broken..
Also, here's a pic of the error..![]()
Sub Converter() ' ' Converter Macro ' ' Keyboard Shortcut: Ctrl+m ' Dim myVar As Range Set myVar = selection With myVar .NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)" .Columns.AutoFit End Sub
VBA Error.png
Bookmarks