Locate a specific row or column

[clara]

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

 

[Jim Jackson]

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

 

[Sandy]

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