Marco,

dim r as range
set r = new range

creates a range object, but doesn't actually assign it to a physical range.

so something like

set r = Worksheet("Sheet1").Range("Test")

is required to actually assign a range to the range object, and then
whenever you refer to r it implicitly refers to Test.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Marco Roberto" wrote in message
...
Hi,
is there anyway to create a range in memory like:
dim r as range
set r = new range
or I really need to set a range in a worksheet like:

set r = Worksheet("Sheet1").Range("Test")

Tks,

Marco