Easy question here. I am trying to reference a string from one worksheet and display it on anther worksheet.
Code is below. It works if I use
Name1 = Range("B2").Value
for example, but I want it to use the user input row labeled LSG below.
Name1 = Range("B" & LSG).Value
does not work. Why? I'm guessing it's a simple keyword I'm missing.
Sub SG1()
Dim LSG As Integer
Dim Name1 As String
Sheets("Size").Select
LSG = Range("J2").Value
Name1 = Range("B" & LSG)
Sheets("Sheet1").Select
Range("B13").Value = Name1
...
End Sub
Code is below. It works if I use
Name1 = Range("B2").Value
for example, but I want it to use the user input row labeled LSG below.
Name1 = Range("B" & LSG).Value
does not work. Why? I'm guessing it's a simple keyword I'm missing.
Sub SG1()
Dim LSG As Integer
Dim Name1 As String
Sheets("Size").Select
LSG = Range("J2").Value
Name1 = Range("B" & LSG)
Sheets("Sheet1").Select
Range("B13").Value = Name1
...
End Sub