Tom: Thanks for pointing out
As is only used in a declaration/DIM statement.
Initially I didn't have the "As Range" part.. only
added it thinking that was what was needed..
I failed to remove from my post, but glad now I left it
in as I didn't know the above rule you just gave me; and this rule is good
to know.
Tks,
Jim

"Tom Ogilvy" wrote in message
...
As is only used in a declaration/DIM statement.

set rng = Range("TestRange").Resize(5,3)

is possibly what you want.


or perhaps

Range("TestRange").Resize(5,3).Name = "TestRange"

to redefine TestRange
--
Regards,
Tom Ogilvy

"Jim May" wrote in message
news:ND%Ad.15517$jn.4876@lakeread06...
In a new wb and ws:
In the Immediate Window I enter:
range("A1:A10").Name = "TestRange"
? Range("TestRange").address
$A$1:$A$10 <<< results of above line
Range("TestRange").Resize(5,3) As Range << When I enter this I get

Compile error:

Expected: End of Statement

Why?