Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
I open the template and import my data so the report populates. I need to recenter (no merge) the title because I have fewer columns than I did on my original template.
I attempt to use the macro again and it has no effect. I deleted the rows completely, added the rows back, and the macro reset so I was able to center no merge across fewer columns than on my original template.
Why is this happening, and how can I get the macro to let me shorten the position (across fewer columns) of the center no merge WITHOUT deleting the original rows each time? Read More