Hi I need to specify the columns of a Spreadsheet using arguments. This is what I need:
("B2:B38,C2:C122")
And this is what I have
When I execute this line the result is Columns = ("B2:B38C2:C122")Code:Dim Columns As String CellEnd = 122 CellBeg = 38 Columns = (("B" & CellBeg & ":" & "B" & CellEnd)) & _ (("C" & CellBeg & ":" & "C" & CellEnd))
I DO NOT get the coma in between and that is giving me an error. What will be the right format to get this right? I am still trying to solve it.
Thanks


Reply With Quote