Unable to Match property of Worksheet class function

**bambino_32** · 01-28-2010, 01:47 AM

Hi in below stated code i do get this error:
Unable to Match property of Worksheet class function.
It seems I made everything right, but I cannot figure out why this message appears. Hope you can find out the problem...

Please Login or Register  to view this content.

**pike** · 01-28-2010, 03:30 AM

hi bambino_32
Try this....

Please Login or Register  to view this content.

**romperstomper** · 01-28-2010, 05:35 AM

I assume there is some code missing that actually assigns a value to startday, so try this:

Please Login or Register  to view this content.

**Andy Pope** · 01-28-2010, 05:38 AM

The error is raised because the Match function fails to find a match.

You can use error trapping to catch no finds.

Please Login or Register  to view this content.

Dates are really tricking things to find. You may need to convert the date to a number.

Unable to Match property of Worksheet class function

LinkBack

Thread Tools

Rate This Thread

Display

Unable to Match property of Worksheet class function

Re: Unable to Match property of Worksheet class function

Re: Unable to Match property of Worksheet class function

Re: Unable to Match property of Worksheet class function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions