Help with counting rows

  • Thread starter Thread starter plm11111
  • Start date Start date
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
 
iLastRow = Range("A1").End(xlDown)
Range("B1").Resize(iLastRow,3).Value = "y"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting different rows daily and running a Macro 3
Help with column 2
Helps with Macros 5
Problem with formatting , need to get rid of decimal point ..... 1
Counting Rows 3
Counting Cells with Conditional Formatting 7
Count and store number of rows 4
how to fix starting point when counting rows? 5

Back
Top