MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

hurricane_run in reply to @NotThamesWater

Coloured in spreadsheets are the bane of my life. Along with merged column headers....

•

aggi in reply to @hurricane_run

I have a macro that opens every file in a folder and removes any merging.

•

NotThamesWater in reply to @aggi

And then emails the person that did the merging to call them a twat.
•

stelfox in reply to @aggi

I am in awe

Many years ago I did weekly ad reporting that required me to manually download a lot of files. Even selecting the 'raw' option gave me an xls with multiple merged column headers.
•

hurricane_run in reply to @aggi

I also hate macros.. where did that hard coded value come from?
Cntrl [ functionality.

Edit to add.. why do people use macros when PQ exists within Excel?