Deleting rows

[JGarces]

Hi all,

I'm not very proficient in VBA, but I'm trying to create a macro that would do the following:

I have several tabs in a worksheet. A large table is downloaded in each tab every day. A macro selects the data that is useful and gives the data a code, and if the data is not useful, it returns a "N/A" in column A. Because the rows of useful data is never constant, this is what has been problematic for me.

Is there a macro that would find where the useful data ends (or the no useful data (N/A) starts) and then find the last row of the table (some days data has 3,400 rows, next day could be 10,000 rows) and deletes all of the non useful data (N/A).

Any help is highly appreciated,

Thanks --
JGarces

[vinaysri11]

JGarces,

Please insert the following lines after your code in macro.

Please Login or Register  to view this content.

This will delete all the unuseful rows which contains "N/A" in column A.

[VBA Noob]

Vinay,

Please read forum rules below (Rule 5). All code must be wrapped (tagged)

VBA Noob

[JGarces]

Thank you very much Vinaysri11, the code worked very well and very fast.

JGarces