I'm writing a VBA Macro that will move the first row of the selected
range to row 4 and scroll the other rows and could use a tip ...


Now,


I have a worksheet where the first three rows are frozen ...


I'd to attach two buttons that should work like named anchor tags work
in HTML ...


When I click on the first button the row numbers should look like


1
2
3
100


And when I click on the other button the row numbers should look like


1
2
3
165


The numbers 100 and 165 correspond to the first row of a named rang -
but a solution
referencing row numbers works great.


Any suggestions?


Thanks.