Can anyone tell me why this code is giving an error when in along with the rest of the code in the attached workbook but when its on its own works fine?
Please Login or Register to view this content.
Can anyone tell me why this code is giving an error when in along with the rest of the code in the attached workbook but when its on its own works fine?
Please Login or Register to view this content.
Change the name of the Day() procedure in Module1. It conflicts with the Day function.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Because you named one of your Subs Day. You should never name a sub after an Excel Function.
Thats great thanks for the feedback. Working perfectly now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks