How to find speicial cell using macro

[blesswo]

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

 

[Jim Rech]

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

|
| 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?action=getinfo&userid=14907
| View this thread: http://www.excelforum.com/showthread.php?threadid=265358
|