GreenthumbUK
MIS
Hello,
I want to pick up a peace of text from a named range "Group_Reference", then drop it in another cell.
Instead the below code is reporting Group_Reference as text instead of the text entered in Group_Reference, any ideas.
Sub group_Reference()
Dim group_Reference As Range
Application.ScreenUpdating = False
Application.Run "Unlock_WorkshLS"
Sheets("WorkshLS.XLS").Select
Range("A600").Select
ActiveCell.FormulaR1C1 = "group_Reference"
Application.Run "Lock_WorkshLS"
Application.ScreenUpdating = True
End Sub
I want to pick up a peace of text from a named range "Group_Reference", then drop it in another cell.
Instead the below code is reporting Group_Reference as text instead of the text entered in Group_Reference, any ideas.
Sub group_Reference()
Dim group_Reference As Range
Application.ScreenUpdating = False
Application.Run "Unlock_WorkshLS"
Sheets("WorkshLS.XLS").Select
Range("A600").Select
ActiveCell.FormulaR1C1 = "group_Reference"
Application.Run "Lock_WorkshLS"
Application.ScreenUpdating = True
End Sub