Hi, This is my first post on this forum, so here goes.
I am using Office 2013 and I have a spreadsheet that has downloaded currency data in some cells, but it is in a European format i.e. decimal, point for thousand separator and comma for decimal point.
I need to record a "replace" macro that will be applied ONLY to a selection of cells that I will select immediately before running the macro. The range will be different every time.
I have no problem recording the macro, but when I run it, it applies the formatting to the entire worksheet.
How can I apply the macro to a selection of cells only?
Tommy
Bookmarks