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
 
1. check your declartion. Declare as Range

2. popfromzone. or PopFrom.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

after a .Find command, offset the output 2 rows down. 6
Object variable or with Block variable not set 9
Setting A variable name From Loop 9
VBA equivalent to =OFFSET(.... 2
Normal.dot Error 3
Declaring Offset as a variable 3
Run time error 13 - type mismatch 6
Another For each headache I get 6

Back
Top