Hey guys
I am wondering how i reference a cell value (number) from within a macro.
I essentially want the number in the cell to populate in the macro;
macro is here;
Sub KeywordCombo()
Dim i As Long
Dim j As Long
Dim k As Long
Dim l As Long
For i = 1 To 26
For j = 1 To 26
For k = 1 To 26
l = l + 1
Range("D" & l) = Range("A" & i) & "|" & Range("B" & j) & "|" & Range("C" & k)
Next k
Next j
Next i
End Sub
Where "26" is, I want to reference cell F2, then G2, then H2
I tried Range(“H2”).Value but that doesn't seem to work.
Thanks
Bookmarks