If continous 4 rows have the same row height then
Hey guys,
how do I check over the entire used range of my WS for 4 continous (in a row) rows that contain the same row.height. If found then then delete all 4 rows, and continue on for the rest of the WS until the last used row has been checked.
regards
jordan
Before running this code on your worksheet make sure you do this on a backup as you cannot undo the changes made by VBA code. Backup your workbook first. It is best to upload a sample workbook showing your data making sure all sensitive information has been stripped from the sample workbook however based on your description the following code should do what you require.
Please Login or Register to view this content.
Hope this helps.
Anthony
Pack my box with five dozen liquor jugs
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks