Hi there,
This is probably quite simple, but I haven't found the answer on the forum or elsewhere... please help
So the idea is that it is going through a set of data one row at a time (using TableRow), and the first task is to extract the ProjectNumber from column d of the row.
The final line of my code (ProjectNumber = etc) gives me a type mismatch error when I run it.
The same result occurs with:
On the other hand, if I do this:
I get this error instead:
Object variable or With block variable not set
...which makes no sense to me as ProjectNumber is not an object (unless Range is an object of course, but in that case surely I have set it?)
Confused!!
Any help appreciated... thanks
ssu95bm
Bookmarks