rowabsolute, columnabsolute of address property

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

hello.

Is there any way to universally set the rowabsolute and
the columabsolute parameters of a range's address property
to false?

In case I was unclear writing that, this is what I mean:

dim rgThing as range
dim stFormula as string

set rgThing = Range("a1")
stFormula = rgThing.address
(rowabsolute:=false,columnabsolute:=false)


The default seems to be to use the absolute referencing,
which ends up as '$a$1', and generally want it to be 'a1'

Can I reset the default somewhere?

Thanks.
 
Mark,

No, you can't do this. You always need to include the arguments
to the Address property if you want a relative address.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You can't change the default. To save typing, you could use:

(False, False)

or less advisably:

(0, 0)
 
Back
Top