How to find speicial cell using macro
 

I just start using macro, and I have a simple question.

I have sorted number from 1 to 200, how can I use macro to get th
cells with the value from 120 to 125?

Thanks a lot

--
blessw
-----------------------------------------------------------------------
blesswo's Profile: http://www.excelforum.com/member.php...fo&userid=1490
View this thread: http://www.excelforum.com/showthread.php?threadid=26535

How to find speicial cell using macro
 

I don't know what you mean by "get" but if you know where the first cell is
and that the numbers go down from 1 to 200 with no gaps then number 121
would be at Offset(120) from the first cell.

Range("FirstCell").Offset(120).Select

--
Jim Rech
Excel MVP

"blesswo" wrote in message
...
|
| I just start using macro, and I have a simple question.
|
| I have sorted number from 1 to 200, how can I use macro to get the
| cells with the value from 120 to 125?
|
| Thanks a lot.
|
|
| --
| blesswo
| ------------------------------------------------------------------------
| blesswo's Profile:
http://www.excelforum.com/member.php...o&userid=14907
| View this thread: http://www.excelforum.com/showthread...hreadid=265358
|