Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Any way that the code below can be made to return me to the worksheet and
cell were the code was triggered? Sub HolidayRemove() 'Code provided b Mike H Application.ScreenUpdating = False On Error GoTo ErrorHandler For n = 1 To Sheets.Count If Sheets(n).Name < "Holidays" Then Sheets(n).Select Sheets(n).Unprotect With Sheets(n) Range("S5").Activate ActiveSheet.Shapes.SelectAll Selection.Delete Range("K1").Value = "" Sheets(n).Protect End With End If Next n ErrorHandler: Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enter doesnt return to the cell below the starting point anymore | Excel Discussion (Misc queries) | |||
Go back to starting point | Excel Programming | |||
Indexing Values to Same Starting Point for Relative Return Chart | Charts and Charting in Excel | |||
bar chart starting point | Charts and Charting in Excel | |||
Starting Point of macro | Excel Programming |