COUNT

  • Thread starter Thread starter jackcwood
  • Start date Start date
J

jackcwood

Hi I need some script to count a rows in a column in sheet1 & in
sheet2 pate value in cell a1, then a2 when macro is run again and so
on a3,a4 this is so that i can audit if any rows have gone missing.

Thanks
 
Your request is short on details.

What sort of data is it? What outcome do you want? Paste what into
Sheet2, cell A1?

FYI-
To count used rows in column A, try =COUNTA(A:A)

Substitute A:A for your column of choice.


HTH,
JP
 
Back
Top