cursor goto a5 in Sheet1 but

S

Steved

Hello from Steved

The below macro works as I require.
Please If I am working in sheet2 how do I get the cursor please to goto A5

Sub SaveNClose()
ActiveWindow.SmallScroll ToRight:=-25
Application.Goto Reference:=Worksheets(1).Range("A5")
ActiveWindow.SmallScroll ToRight:=-25
ActiveWorkbook.Close True
End Sub
Thankyou.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SaveNClose 4
Macro to scroll to Cell A5 please 2
Reference is not valid 1
Sub SaveNClose() 2
Macro works on some but not for all 0
Active sheet instead of a "sheet1" for Macro 7
Print Macro code help 1
Macro 0

Top