Avoid Switching Sheets, Reference Sheet Without Switching Instead.

Here is the code:

Please Login or Register  to view this content.

I would like to be able to use the TargetRange variable instead of J2:J30000, as it is dynamic, and I wouldn't have to switch sheets to do the calculation. But it doesn't seem to want to take a variable or a concatenation thereof.

Essentially, I need the VBA equivalent of the non-VBA 'Sales History'!J2:J30000, which I thought I had covered in the TargetRange variable.

No workbook; no test

Please Login or Register  to view this content.