Creating a range

[Bob Phillips]

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]

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

 

[Bob Phillips]

Marco,

I don't get it. As I said, in VBA you create a range object, it has to refer
to something otherwise it is null, and you can't do a lot with a null
object.

--

HTH

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

 

[Marco Roberto]

Bob,

first of all, thaks for your reply. In fact, I don't want to refer to
Test. I just want to
create the range in memory and perform some operations with this range like:
input some
values, etc. I will use this range as a parameter to the DSum
worksheetfunction.

Tks