Good morning all!
I'm currently working on updating a macro I created for the purpose of formatting large sets of data into easily-readable reports. One particular part of the code is really slowing things down, but I don't know how to clean it up or make it more efficient. The purpose of problematic code is to check each cell within a defined range. If the row height of an individual must be greater than 25 in order to fit all data in a cell, the entire row is autofit to that height. If the row height is less than or equal to 25, then the row height is set to be 25. I also inserted a "Lastrow" function for excel to determine the last row with data in it and only run the above formula through that row. Unfortunately, it seems like the formula is running well beyond those parameters, so I think there may be something off with my code. Can anyone help? The code is posted below.
Please Login or Register to view this content.
Bookmarks