Number in column

[someone21]

I want to have a macro to be put in another worksheet( say Sheet1) to make the Column A of Sheet 2 start from 1, 2,3,4,5,6 depending if the row is empty.

Meaning, if row is not empty, I want a number to be added.

And the 1st row is headings, so no numbering in A1.

 

[Andrew Poulsom]

What do you mean by "if the row is empty"? What column(s) do you want to test? By the way you won't need a macro for this - you can use a formula like:

=IF(COUNTA(B2:C2),MAX(A$1:A1)+1,"")

 

[someone21]

I want a macro for this reason,

The idea is first to see every row from Row 2 till the end of page, and if the row contains some data, I want the column A of the row to be named "1" and so on. So example, the 2nd row with some data, I should get number "2" in the column A of the row.

 

[Andrew Poulsom]

Did you try the formula I posted?