Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset Method and Interpreting Absolutes in Range Objects
I have the following code below which offsets a cell range. Two questions:
1) Why is the row (7) absoluted in the revised range? 2) The Offset does not appear to recognize the fact that the cell $A7 has its column absoluted therefore it increments this to column "B". Why is this (aside from the fact that I told it to do it (0,1)? Is there a way of using the Offset Method to have it interpret absolutes properly? Thanks Suspectedrng= "$A7" Set r = Range(Suspectedrng) RevisedRngRight = r.Offset(0, 1).Address ?RevisedRngRight $B$7 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolutes in Formulas | Excel Worksheet Functions | |||
Absolutes? | Excel Discussion (Misc queries) | |||
Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Can I use a defined integer in an OFFSET method? | Excel Programming |