Excel Vb Question:
When I call the following function:
cf2 = ws2.Cells(r, 3).Value
cf2 gets populated fine.
BUT! if i create a variable column2 and set it to "3" and use:
dim column2 as long
column2 = InputBox("Enter the column number")
cf2 = ws2.Cells(r, column2).value
cf2 gets populated as an empty string???
What am I doing wrong?