Good day all,
I have a macro that picks out rows of information based on the the word "CAR" being in the contents of one column in sheet "2012" & sends this information to another sheet "CARReport", row by row. The macro works but when I need to update the sheet it doesn't clear the original information, e.g. If there are no "CAR" reports I need it to clear the sheet, basically I need to perform a refresh before the macro performs?
Help!
Last edited by matrixpom; 10-01-2012 at 09:36 PM.
Hi, matrixpom,
from what I understood from your question (and I assume you have headers in row 1 from A1 to AZ1) try something like this prior to your original macro:
If there is only data you may try
Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger,
I've tweaked Your first line to "Sheets("CARReport").Range("A1:AN1000").ClearContents" & it works perfectly,
grazie mille Holger
Ciao
Marco
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks