There are some tasks I want to perform on each sheet in a workbook and I'd like to do this without Select and/or Activate statements. I utilize a cell on each sheet as my "home base" and then offset from there, however, when I try to assign a variable name to a cell on a sheet other than the current one, I get a 1004 error. My code is as follows:
Set HomeSpot = Sheets("SheetsNum").Range("a1") .Range("B4")
This is the line that errors out, even if I just do a short macro trying to select the cell on another sheet. How can I rewrite the code to pass muster? Thanks!
P.S. Same error if I precede the above code with "Acvtiveworkbook." and/or use Worksheets instead of Sheets .