![]() The UsedRange property gives us a range that encompasses the cells that have been used to enter data. In this macro, we are using the UsedRange property of the Activesheet object to define the range we are working with. If Application.CountA(Rows(iCounter).EntireRow) = 0 Then 'Step 4: If entire row is empty then delete it. 'Step 3: Start reverse looping through the range.įor iCounter = To 1 Step -1 3.1 Don't see personal.xlsb in your project window?.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |