View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jim Jackson Jim Jackson is offline
external usenet poster
 
Posts: 324
Default 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