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

On Mar 19, 8:32*am, wrote:
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