Thank you, this is actually helping me a lot!!! And your solution works perfectly! And forgive my ignorance, but can you explain why the syntax is how you referenced it and not like
where vc.document_id in (" Sheets("210").Range("$G$2: G" & LastRow) ")" & _
or even with something like this:
'Sheets("210").range("$G$2:G" & Range("B" & Rows.Count).End(xlUp).row)
The reason why I am asking is because I need to run this code for 9 other pages so I am going to have to reference the sheet and the specific column for example please see the image below.
I need to input all of the contents in column G starting from G2, but this data changes from sheet to sheet meaning that there will be more records on 1 page than another and I need it to grab all records for that page. Let me know if this makes sense.
Once again thank you!!!!