Hi - I have a spreadsheet where the user put in the starting cell of data that's to be used. So they would put "G7" in cell B2. I'm trying to get code that will split that G7 into row and column. I was using the code below that had the user enter the row and column separately, but it's much simpler to have them enter both together. Any help is appreciated.
VBA Code:
Dim rng As Range
Dim colFR As Variant
With ws2
colFR = .Range("B2")
Set rowFR = .Range("D2")
End With
Dim LastRow As Long
With ws1
LastRow = .Cells(.Rows.Count, colFR).End(xlUp).Row
Set rng = .Range(.Cells(rowFRD, colFR), .Cells(LastRow, colFR))
rng.Copy ws3.Range("A3")
End With