View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Set Focus to Worksheet and then a specific ROW

application.goto worksheets("sheet99").range("b99"), scroll:=true

would be one way.

HotRod wrote:

As the header says I need to select a worksheet and then make one of the
rows in the work sheet visible to the user so that they know where I've made
a change. Code????

I have to worksheet selected but how do I do a specific row?


--

Dave Peterson