My macro is running from sheet2 (from a button)
Why do I get an error with this?StartNum = 7, EndNum = 15 and dateNum = 8 (checked these in the VBA Editor and they work out) I get an "application defined or object defined error with the range statement.
Please Login or Register to view this content.
Thanks in advance.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
you didn't qualify the Cells properties
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Possibilities:
1. ColorNum is empty
2. Since you are running from Sheet2, I would use
Just a thought.Please Login or Register to view this content.
Vikas B
Thanks, I had defined ColorNum, just forgot to mention it. It was the .cells. Didn't know I had to do that. Thanks again.
cool...
It was good to know that even Forum Gurus gets stuck sometimes
Cheers!!!
Vikas B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks