cursor goto a5 in Sheet1 but

G

Guest

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

Macro to scroll to Cell A5 please 2
Reference is not valid 1
SaveNClose 4
Sub SaveNClose() 2
error message. 2
find the last Fred and goto cell 6
Active sheet instead of a "sheet1" for Macro 7
Run-time error "1004" Select method of range class failed 3

Top