Hi all,
I'm using this code to tidy-off my report worksheet at the end of some code...
Report1.Range("D5").Select
Application.Goto Report1.Range("D5"), Scroll:=True
This SHOULD position the report nicely as I have frozen the pane at D5.
And this code works in other reports.
So, why is my new report code just refusing to do either of the above statements ?
Have I missed something obvious ?
I've tried Report1.Select Report1.Activate - makes no difference.
Any suggestions greatfully received.
I'm using this code to tidy-off my report worksheet at the end of some code...
Report1.Range("D5").Select
Application.Goto Report1.Range("D5"), Scroll:=True
This SHOULD position the report nicely as I have frozen the pane at D5.
And this code works in other reports.
So, why is my new report code just refusing to do either of the above statements ?
Have I missed something obvious ?
I've tried Report1.Select Report1.Activate - makes no difference.
Any suggestions greatfully received.