'1004 Error' Message

[BexleyManor]

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.

[ilyaskazi]

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

[BexleyManor]

WOW!! Now thats what I call efficient coding.

Thank you so much my friend, you've saved me from going mad !!