Can VB identify & select dynamic ranges??
Posted by Tom Urtis on April 18, 2001 6:32 PM
In Excel 2000, I import rows of data (records) into the range A2:CZ300. The records vary in size every day, and along with the import comes useless junk starting 2 rows below the useful records which needs to be deleted. I'd like to know if VB code can identify the last row of a dynamic set of records by searching for the first blank cell in column A after A2, and once that cell (A125 or A whatever) is identified, make that cell part of the range (for instance) A125:CZ300, to then delete the contents in that range. Any suggestions? Thanks as always!!