ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Set Focus to Worksheet and then a specific ROW (https://www.excelbanter.com/excel-programming/345366-set-focus-worksheet-then-specific-row.html)

HotRod

Set Focus to Worksheet and then a specific ROW
 
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

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


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com