LinkBack URL
About LinkBacks
I use R1C1 notation when putting formulas in cells via VBA. Try
With ActiveCell.Offset(0,7) .FormulaR1C1 = "=VLOOKUP(" & .Parent.Range("C7").Address(false, true, xlR1C1, False, .Cells) & ", R1C3:R99C5, 3, False)" End With
I use R1C1 notation when putting formulas in cells via VBA. Try
With ActiveCell.Offset(0,7) .FormulaR1C1 = "=VLOOKUP(" & .Parent.Range("C7").Address(false, true, xlR1C1, False, .Cells) & ", R1C3:R99C5, 3, False)" End With
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks