setting a variable to the offset of another object declared variab

  • Thread starter Thread starter ironhydroxide
  • Start date Start date
I

ironhydroxide

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
 
Rusty,

For the first one, you need to limit yourself to one cell:

If PopFromZone.Cells(1) = "Zone AV" Then

The second one.... well, you are not setting PopFrom as a range anywhere, and you need to limit to
one cell.

HTH,
Bernie
MS Excel MVP
 
exactly what was needed. Thanks


Bernie Deitrick said:
Rusty,

For the first one, you need to limit yourself to one cell:

If PopFromZone.Cells(1) = "Zone AV" Then

The second one.... well, you are not setting PopFrom as a range anywhere, and you need to limit to
one cell.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Back
Top