Moving between worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had someone do this for me. This is an Excel file with 4 worksheets. The
two pertinent ones are called 'Schedule' and 'Version'. When save the file
it updates the version of the file with a date/time stamp on the 'Version'
worksheet like this.
Version Last Saved (Date/Time)
2004.08.282141 8/28/04 9:41 PM
2004.08.282140 8/28/04 9:40 PM
2004.08.282140 8/28/04 9:40 PM
2004.08.282139 8/28/04 9:39 PM
2004.08.282136 8/28/04 9:36 PM


I would like it to update the 'Version' worksheet and then jump back to the
'Schedule' worksheet so you can continue your work. Can anyone help with
this? Thanks.


The existing macro that I can find is shown below.

Sub Macro1()

Sheets("Version").Select
Rows("2:2").Select
Selection.Insert Shift:=xlDown
Selection.Interior.ColorIndex = xlNone

End Sub
 
You shouldn't have to make selections. You can do this from anywhere in the
workbook
Sub Macro1()

With Sheets("Version").Rows("2:2")
..Insert Shift:=xlDown
..Interior.ColorIndex = xlNone
End With
End Sub
 
Back
Top