fabriciofcmiranda
Board Regular
- Joined
- Jun 27, 2006
- Messages
- 62
I have this code:
The fact is I need to transform the "completename" into "completename.Offset(-1, 0)", since the cell I need to reffer to is the one right above "completename", that changes each time I insert a new line. But I can't figure out a way to transform this into a valid code. Can anyone help me?
Thank you very much!
Code:
Range("projectname").Offset(-1, 0).Select
ActiveCell.FormulaR1C1 = "=completename"
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
The fact is I need to transform the "completename" into "completename.Offset(-1, 0)", since the cell I need to reffer to is the one right above "completename", that changes each time I insert a new line. But I can't figure out a way to transform this into a valid code. Can anyone help me?
Thank you very much!