Locate a specific row or column
 

Hi all,

Could you tell me how to locate a specific row instead of using Mouse to
dray the scroll bar?

Clara

thank you so much for your help

Locate a specific row or column
 

In VBA code, you can use:
Range("D100").Activate
' Or
Range("D1:D100").Select
' Depending on if you want only one cell highlighted or a range of cells.
--
Best wishes,

Jim


"clara" wrote:

Hi all,

Could you tell me how to locate a specific row instead of using Mouse to
dray the scroll bar?

Clara

thank you so much for your help

Locate a specific row or column
 

Hi Clara

Have you tried goto in the Edit menu (or shortcut Ctrl + G)
Example; to go to row 100 type A100 in the reference box.

Sandy

"clara" wrote in message
...
Hi all,

Could you tell me how to locate a specific row instead of using Mouse to
dray the scroll bar?

Clara

thank you so much for your help