I get the "Object variable or With block not set" for the TempName.Address. This is the same code I use for 6 other variables I'm naming on 2 other sheets (this one being the 3rd) in the workbook.

Could this be because the worksheet it is pulling from has multiple "TEMP" entries in column "A"? I didn't think it would do that if I specify it to select the 2 columns next to it....am I missing something obvious?


I've attached a sample workbook that doesn't include everything just the error...
Test_EX.xlsm