NickHK wrote:
You can't OFFSET over different worksheets, if that's what you are trying to
do.
Is "lines" a named range on worksheet3 ?

Does this what you need ?
worksheet3.Range("lines").Offset(0,5)...
As I have it, "lines" is just a name assigned a number in worksheet3.
Say "lines" is 3. Then I want the statement OFFSET ("lines",4) to mean
OFFSET(3,4). I just can't come up with the correct syntax for the
"lines" argument.

Thanks for your help.