LinkBack URL
About LinkBacks
Hi, i have this code and its only clearing the data in column A. All i want is to find blank cell in column A and clear 10 ROWs after that blank cell. Should clear columns A B C D E & F. Thank you.
Please Login or Register to view this content.
Hi, i have this code and its only clearing the data in column A. All i want is to find blank cell in column A and clear 10 ROWs after that blank cell. Should clear columns A B C D E & F. Thank you.
Please Login or Register to view this content.
Please Login or Register to view this content.
OR
Please Login or Register to view this content.
Last edited by AB33; 04-20-2015 at 10:14 AM.
the correct code
Sheets("Input").Range("A" & LastRow - 7 & ":" & "F" & LastRow).Resize(9).EntireRow.delete
Hey AB33, that worked great but when there is no data and i run the macro, why do i get error message 'application defined or oject defined error'?Originally Posted by AB33
It is because of this line
LastRow - 7
By default if a sheet is blank, you get the last row as 1, so you can not deduct 1 from 7. Your last row should be a minimum of 8 rows.
Please Login or Register to view this content.
Last edited by AB33; 04-20-2015 at 10:25 AM.
Thanks guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks