Hi,
I have attached a sample spreadsheet. I have a report that is copy and pasted from another system and I am trying to write a macro to clean up the formatting and make it easier to read and print. I am trying to change the row height to 1.5 in any row where all the cells in the selected range are blank. There are two columns off to the right that have formulas so I am unable to use the Select blanks, entire row codes that I found when I was researching.
Thank you.
See if this works for you
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Is it what you want ???
If you want to check from column A to F use For J = 1 To 6Please Login or Register to view this content.
Last edited by PCI; 11-13-2019 at 04:48 PM.
- Battle without fear gives no glory - Just try
Anther one for the fun
BTWPlease Login or Register to view this content.
if you want to check from column A to F use Rg.Resize(1, 6)
Last edited by PCI; 11-15-2019 at 03:25 AM. Reason: Typo
Perfect. Thank you for the note--I had a much larger range than my example and adapted it accordingly.Originally Posted by PCI
Is it what you want ???
If you want to check from column A to F use For J = 1 To 6Please Login or Register to view this content.
JLGWhiz - Thank you for the code as well. It mostly did what I needed it to, but it caused the title rows to be minimized as well. I am not 100% on what the code does, but I think it is using a number (sum 0) to identify the rows, but rows with all text don't have any numbers and therefore are minimized.
That is exactly correct. The title row can be omitted by the range parameters of the loop. I was just basing it on the sample file provided.JLGWhiz - Thank you for the code as well. It mostly did what I needed it to, but it caused the title rows to be minimized as well. I am not 100% on what the code does, but I think it is using a number (sum 0) to identify the rows, but rows with all text don't have any numbers and therefore are minimized.
Super
Enjoy EXCEL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks