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

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

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