Excel change by 1 month
Excel change by 1 month
- Subject: Excel change by 1 month
- From: Mail <email@hidden>
- Date: Sun, 14 Dec 2008 19:10:13 +0000
I have just upgraded to Office 2008 and rewriting my marco's in
Applescript because Office now doesn't support VBA anymore. I want to
change dates in my expenses to the next month. I was using the below
macro.
Sub NextMonth()
Dim i As Integer
For i = 3 to 21
Sheets("Expenses").Range("A" & i) = dateadd("m", 1,
sheets("Expenses").Range("A" & i))
End Sub
Can anyone help with this.
Also if I want to put a line in to describe what the Script is doing
at at any point, how do I have to start it.
Thanks
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden