I've got some code that says this:
"Controls" is a one cell named range, that serves as a "Put the data here" handle.
This works fine if sheet6 is the active sheet, but fails otherwise with this error: Method 'Range' of object '_Worksheet' failed. Obviously I don't quite have a handle on how to qualify references. Can anyone tell me where I'm going wrong here?
Code:
Set TabOrderRange = Sheet6.Range("Controls", Cells(iTabOrderCount + 1, 3))
This works fine if sheet6 is the active sheet, but fails otherwise with this error: Method 'Range' of object '_Worksheet' failed. Obviously I don't quite have a handle on how to qualify references. Can anyone tell me where I'm going wrong here?