Thread: setting a variable to the offset of another object declared variab
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ironhydroxide ironhydroxide is offline
external usenet poster
  
Posts: 51
Default setting a variable to the offset of another object declared variab
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


Reply With QuoteReply With Quote