asked on Concatinating with variable name.
I have been trying to concatenate a named ref with a cell and it is not working... any ideas?
If PO is: 123456789 and RC[-1] is 3000 I am looking to get: 123456789/3000
PO = ActiveCell.Value
ActiveCell.Offset(0, -5).Select
ActiveCell.FormulaR1C1 = "=CONCATENATE(PO,""/"",RC[-1])"
If PO is: 123456789 and RC[-1] is 3000 I am looking to get: 123456789/3000
VBAMicrosoft Excel
Last Comment
RWayneH
ASKER
I really need to use ActiveCell in this case.... are you saying this cannot be done? Your Ln1 will not work, because it is in a While Loop and the value of PO chg's throughout the loop.
ASKER
Rather than get into redesigning the whole Do While.... I would like to be able to use a named reference for an ActiveCell in the concatenation.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You should try it like this....
Dim PO As Range
Set PO = ActiveCell
ActiveCell.Offset(0, -5).Select
ActiveCell.FormulaR1C1 = "=CONCATENATE(" & PO.Address(ReferenceStyle:=xlR1C1) & ",""/"",RC[-1])"
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Appreciate the help. Thanks
Try below:
Open in new window
If you can provide me the exact cells, I can write a code, then you don't need to use ActiveCell