My code has just recently stopped worked breaking with an "Object variable or With block variable not set." at the line in red.
My guess is the 'set ref_date' reference has failed. But I have no idea why?Please Login or Register to view this content.
tdate = 1/3/2019
ws_target is a recognized worksheet
ws_schedule is also a recognized worksheet referring to a worksheet in a second open workbook
Column B, row 2 holds the date 1/3/2019, although formatted as ddd dd-mm.
red_date is defined as a range
Is anyone able to offer some support?
Bookmarks