Hello,
I have a macro I found on another forum that I really like to use. The macro will search every cell in the active sheet to see if they are merged. If they are, it stores the range of the merged cells in a temp. range variable, unmerges the cells, then fills the range with the value of the first cell in the unmerged range (what the value was).
The macro is saved in my personal macro workbook. I've tried lots of different ways and I cant seem to make the macro excuted on any spreadsheet I am unless i copy and paste the data into the personal macro workbook then excuted the macro. Can anyone help me figure out why it would only run in my personal macro book but not any other workbook even though the code says "active workbook?"
Thanks in advaced for your help. I have placed the code below.
Please Login or Register to view this content.
Bookmarks