• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

Using variables within the offset

Here is a simplified version of what I am trying to do:
Dim State as integer, r as range
Set r = range("A1")
State = 10
If r.Offset(0, State).Value = "Texas" Then ....

Assuming r.offset(0,10).value does equal "Texas", what am I doing wrong in this line:
If r.Offset(0, State).Value = "Texas" Then ....
0
tiehaze
Asked:
tiehaze
1 Solution
 
Wayne Taylor (webtubbs)Commented:
Hi tiehaze,

It look OK to me. Given that r=A1 and State=10,  r.Offset(0, State).Value gets the value from L1. Is this correct?

Regards,

Wayne
0
 
tiehazeAuthor Commented:
nevermind... i got it to work, thanks for the confidence :)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now