still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 826
- Office Version
- 365
- Platform
- Windows
Hi,
I use this when a workbook opens
The macro “movebox” goes to the range “loans” and moves it down a line
Is there a way to only run this after the wookbook opens 5 times and not every time
mike
I use this when a workbook opens
VBA Code:
Private Sub Workbook_open()
Sheets("sheet1").Select
movebox
opening
End Sub
VBA Code:
Sub movebox()
Range("loans").Select
Application.CutCopyMode = False
Selection.Cut
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
Range("A1").Select
End Sub
mike
Last edited by a moderator: