-
Solved: '1004 Error' Message
A collegue has passed this workbook over to me to have a look at as it keeps firing an 1004 error message. The Macro has been created with the recorder so the code doesn't appear that efficient yet I can't work out why the error happens ??
Can any of you super coders out there please help as it's driving me mad!!
Also, If any of you have suggestions for a better way of coding this then I would be sooo grateful.
Thanks folks.
-
Just try this single line code:
[VBA]Sub MacroTest()
ActiveWorkbook.CustomViews("wk" & Sheets("Sheet1").Range("Week")).Show
End Sub[/VBA]
Assign your command button macro to MacroTest and check...
HTH
ilyaskazi
-
WOW!! Now thats what I call efficient coding.
Thank you so much my friend, you've saved me from going mad !!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules