setting a variable to the offset of another object declared variab
1. check your declartion. Declare as Range
2. popfromzone. or PopFrom.
--
If this post helps click Yes
---------------
Jacob Skaria
"ironhydroxide" wrote:
I am having problems with offset. i cant seem to get the offset function to
set a variable to the offset of another variable (a cell) here are a couple
code snippits that i have tried already.
Set PopFromZone = Selection.Offset(0, 2)
If PopFromZone = "Zone AV" Then ' type Error 13 Type Mismatch
If PopFrom.Offset(0, 2) = "Zone AV" Then 'Run Time error 434 Object
Required
Thanks for replies
Ironhydroxide
|