Error - Object variable or With block variable not set

[mactoolsix]

I have two macros which work fine separately. I have combined them (see the line ' insert 12 columns and label) - now get an error.
Object variable or With block variable not set
I have no idea what this means. The macro executes all the way through to this section, then the error pops up:

Please Login or Register  to view this content.

Here's the full code:

Please Login or Register  to view this content.

Any help would be much appreciated!!
Thanks,
Mike

[kalak]

a common cause for that error is if "This Year" doesn't occur in the range of interest

it's often handled by this sort of code

Please Login or Register  to view this content.

[mactoolsix]

kalak,

Thanks for the response.

"This Year" doses NOT occur in the range. It is on the next sheet and the range is defined for the first section on the first sheet.

That's why I entered the line to change sheets "Expense Tracking" . Select

How can I redefine the range for the second part on the next sheet?

If you have any ideas - much appreciated!!!

Mike

[kalak]

Mike,

It's not totally clear to me just where you're at, but I modified your code a bit (modifications untested) so you can try it to see if it does anything sensible for you

Please Login or Register  to view this content.