Can some help me how to concatenate string and number ? Please find my code below:
Dim nodCells As Range, weightageCells As Integer
Dim selectedRng As String, tempVar As Integer
tempVar = 0
tempVar = Sheet1.Cells.Find(What:="*", _
After:=Sheet1.Range("A1"), _
Lookat:=xlPart, _
LookIn:=xlFormulas, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Row
Range("b2").Value = tempVar
Set nodCells = Range("A1:a" + &tempVal)
I am getting error at the last statement at &tempVal where tempVal is numeric.
Bookmarks