How to start an offset formula on a different row

[TJC86]

I've got the following formula to move down a row each time, but how do I start this formula on row 12, not row 1.

Range("A" & rows.Count).End(xlUp).Offset(1)

Thanks

 

[kvsrinivasamurthy]

This is not a formula. It is code to find last row in A column.

 

[ParamRay]

.
.

Your code points to the last non-empty cell in column A and then points to the cell directly below that.

If you wanted the cell below A12, you could use:

Range("A12").Offset(1,0)

or, more simply:

Range("A13")

 

[saltkev]

Hi

I think this achieves what you have above but starting at "A12", However I think you might need to be a little clearer about what you want to achieve.

Dim Lr, LrRange
Lr = ActiveSheet.Range("a1000000").End(xlUp).Row + 1
LrRange = ActiveSheet.Range("a12:a" & Lr).Address(False, False)


regards

Kev