Easy... but I can't figure it out

[CTS Trinidad]

In my cell A1 I have an Excel function that counts the number of rows that contain numeric values. [ =count(A3:A146)]

I would like my variable 'position' in VB to be attributed this value.

For example:

cell A1 = 35 [indicating that 35 rows within the A3:A146 range contain numbers]

I want my variable 'position' to become 35 or whatever value is calculated in cell A1.

i.e. position = cell(A1)

The procedure must be simple, but I don't know how I should do this?

Thanks for your help.

Louise

 

[macleanb]

Very close:

Position = Range("A1")

or Position = Cells(1,1)

 

[Von Pookie]

Please see:
http://www.mrexcel.com/board2/viewtopic.php?t=128317