Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible offset issue
Intermittently, I'm getting the "wrong" cell chosen when I use this code
r and myaRange reference a single cell. Once recently, myR was one column to the right of where it should have been. Set myR = r.Offset(0, myaRange.Column - r.Column) I had to change the code to this so that it worked. Set myR = r.Parent.Cells(r.Row, myaRange.Column) Has anyone ever seen this before and if so, what's going on? Thanks, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell offset issue | Excel Worksheet Functions | |||
Offset issue | Excel Programming | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
Offset issue | Excel Programming | |||
Offset issue? | Excel Programming |