Help with counting rows

P

plm11111

I have a datafeed that comes to me everyday via email , every day the
feed had slighty different rows as it has different updated products
i.e. somedays 999 , 1001 etc. What i need to do is run a macro so when
the excel file arrives to count the number of rows and then add the
letter "y" in a 3 new columns . At the moment i have to do it manually
is this easy to do

Paul
 
B

Bob Phillips

iLastRow = Range("A1").End(xlDown)
Range("B1").Resize(iLastRow,3).Value = "y"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top