Well, the data will vary day to day. I think, however, it will never go beyond 5,000 rows. So maybe the macro should go to A5000 then stop?

Thanks for the help.

Matthew

vb code question. i am trying to understand how to get a macro using vb to:
if i have a column of numbers, go through the whole column and identify any number that is less than say 10,000 and then select the entire row that number is on and delete the entire row. continue the process through the entire column. also, some cells in the column will be blank (delete), words (delete), and symbols such as # (delete).

i'm a relative...

Hey All,

I am trying to get a macro set up to pull a specific .html file from a public drive, and put the data into an excel spreadsheet as a .txt file would. I used the text import wizard then tried to change the last part (date) of the file name to an asterisk so that it would pull the file no matter what the date was and I would not have to change it daily.

The asterisk was originally "02222007_0 " which...