SELECTING ROWS IN A COLUMN BASED ON A CRITERIA

[navyaa]

I have a cell which contains a numerical value..the cell is called CurCount. I have another column(AZ) which contains values going down the rows. I need to select rows in the column(AZ) till the count is reached.

in LOTUS THE CODE IS:...
SELECT-DOWN TILL (CURCOUNT-2)

Any suggestions?

THANK YOU ...

 

[hedrijw]

This is one way:

If [CurCount] > 0 Then
Range([AZ1], [AZ1].Offset([CurCount] - 1, 0)).Select
End If

 

[navyaa]

WORKS GREAT...

THANK YOU...!!

NAVYA.