We must update the header logos of our reports to reflect the latest corporate rebranding!
Sure! But doing it manually for 50+ worksheets spread across 5+ workbooks is not exactly a quick update…
Nor does it fall under the value-adding category to justify the time spent on manual effort.
There is a quick and painless way to do it with VBA, though!
But how do you know that these are the dimensions you should use for the new logo?
I don’t. I manually resized the logo to the size I wanted and then checked the dimensions by using the following code
Happy VBA coding!