Hi all,
I have the code shown below, which creates a table from another worksheet. In the sheet there are three columns, Date, URN and Location (Eastings and Northings).
The code creates a table, then fills in the table with the date to match a URN to a location, based on a date - essentially so we can see where someone was on a specific date.
Please Login or Register to view this content.
The code is currently failing on the following line:where i get the following error "run time error 91 object variable not set" with this row highlighted yellow.Please Login or Register to view this content.
This line looks at the date down column A, looks at the number in column B to see if there is a match - i.e. 4490 active on 25/10/19. If so a "P" is placed in the corresponding column, to place a green tick in the box.
However, this error keeps occurring and I really dont know why. Variables are declared at the start etc, but it cant seem to find the match, despite it being there.
Any help much appreciated.
Bookmarks