Locate a specific row or column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top