I have a repetitive task where I import XML data into an excel, and then hide certain columns, reformat other columns, sort the data. When I try to record the macro to do all of this, no steps seem to be saved... (using Developer - RecordMacro, (execute reformatting steps) then, StopMacro. Any ideas?
