Creating a range

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

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)
 
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
 
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)
 
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
 
Back
Top