Macro has stopped working after date change

**markrennolds** · 12-01-2009, 11:11 AM

Hi All

I had a macro that was working great all month.

When the date changed today it stopped working and I cant see why as i have altered the dates that it looks at.

Can anyone help? I have attached macro code below & I will attach the sheet shortly.

Thanks in advance
Mark

Please Login or Register  to view this content.

December Targeting Tool.xlsm

**markrennolds** · 12-01-2009, 01:09 PM

Forgot to say that error message is:

object variable or with block variable not set.

Have looked on help section of excel but not making much sense.

Thanks
Mark

**Huron** · 12-01-2009, 07:31 PM

I think it will work if you change the code as shown below

Please Login or Register  to view this content.

**Simon Lloyd** · 12-01-2009, 08:28 PM

Mark, please take the time to read the rules at ALL the places you post as crossposting requires you to add the url(s) of all cross posts.

Cross posted here http://www.thecodecage.com/forumz/me...te-change.html

**Simon Lloyd** · 12-01-2009, 08:31 PM

Originally Posted by Huron

I think it will work if you change the code as shown below

Please Login or Register  to view this content.

Huron yes that will work, Mark didn't tell us what error was at his other posting

Macro has stopped working after date change

LinkBack

Thread Tools

Rate This Thread

Display

Macro has stopped working after date change

Re: Macro has stopped working after date change

Re: Macro has stopped working after date change

Re: Macro has stopped working after date change

Re: Macro has stopped working after date change

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions