I need an easy code that searches all of column A and deletes the entire row if the cell has the value "-". It needs to find the last row of data using something like LastRow = Range("A" & Rows.Count).End(xlUp).Row
I need an easy code that searches all of column A and deletes the entire row if the cell has the value "-". It needs to find the last row of data using something like LastRow = Range("A" & Rows.Count).End(xlUp).Row
try this:
Please Login or Register to view this content.
Last edited by alansidman; 05-07-2014 at 02:53 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Please Login or Register to view this content.
Thanks Bob,
I was just trying to type faster than you can bring things up from OneNote.
Per Bob's suggestion, replace this line in my code
withPlease Login or Register to view this content.
My oversight. Thanks Bob for pointing that out.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks