Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA for Excel
Thanks for your response. I was trying to use RC[-9] to tell Excel use the cell 9 columns to the left of the current cell. RC is Excel keyword and "offsetCol" is the variable I declared. After I posted the question, the problem was solved when a friend told me that I just mixed up...- skong
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA for Excel
Hi, I am trying to use a variable to set the relative position in my formula, but it seems this is not right. Can this be done? If not, is there any other way to do this? I will need to paste the formula for the entire row after this. For normalCounter = 2 To numNormal offsetCol = offsetCol -...- skong
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
