Hi. I'm new to macros/VBA in Excel and have been working through recording some print macros with a good deal of success....until I hit this infuriating roadblock. And it's something that seems like it should be so simple! 
As a final step after auto filtering and formatting my large data set, I just want to change the text in the top left Header cell to reflect the name of the list I'm printing. The name changes depending upon filters and sorts applied (e.g. Retail Stocklist (A-Z), Sale Items (categorised)....). I can get the Header to change once (the first time, assuming I start with a blank Header cell) but after that, no matter what I've tried, how many videos I watch and how much I've Googled, I just cannot manage to delete and/or change the list name/text in the top left Header cell. It's driving me bonkers.
I've tried recording the macros in every order possible (starting blank, starting with text and deleting, header change first, header change last etc etc....), I've tried inserting dummy text (thinking maybe having no text is the issue), I've tried tinkering with the code (my attempt at creating and then referencing a List Name cell value based on filters applied was a spectacular failure), but I just can't seem to solve this problem.
It feels like I'm now well and truly over-complicating what should be a simple task.
If anyone is able to point a Header macro novice in the right direction please I would be incredibly grateful
As a final step after auto filtering and formatting my large data set, I just want to change the text in the top left Header cell to reflect the name of the list I'm printing. The name changes depending upon filters and sorts applied (e.g. Retail Stocklist (A-Z), Sale Items (categorised)....). I can get the Header to change once (the first time, assuming I start with a blank Header cell) but after that, no matter what I've tried, how many videos I watch and how much I've Googled, I just cannot manage to delete and/or change the list name/text in the top left Header cell. It's driving me bonkers.
I've tried recording the macros in every order possible (starting blank, starting with text and deleting, header change first, header change last etc etc....), I've tried inserting dummy text (thinking maybe having no text is the issue), I've tried tinkering with the code (my attempt at creating and then referencing a List Name cell value based on filters applied was a spectacular failure), but I just can't seem to solve this problem.
It feels like I'm now well and truly over-complicating what should be a simple task.
If anyone is able to point a Header macro novice in the right direction please I would be incredibly grateful
