Using the codename for the sheet will:

Sheet1.Range("L18").

or just using the range will:

Range("L18").

Any time there is any ambiguity or doubt on Excel's part, it clams up and is
unhelpful....

HTH,
Bernie
MS Excel MVP

"Spammastergrand" wrote in message
...
You're right. But how about

sheets(1).range("L18").

I could swear that used to bring up a list.