WillyTheFish
10-26-2008, 06:04 AM
Hello ppl,
any idea how i convert a string to a range? I won't get this to work:
Dim strRange As String
'...later on in the function:
strRange = strRange & Sheets(gstrFilename).Cells(lngRow, bytCol).Row & ":" & Sheets(gstrFilename).Cells(lngRow, bytCol).Row & ":"
Range(Left(strRange, Len(strRange) - 1)).Select
thanks in advance!
any idea how i convert a string to a range? I won't get this to work:
Dim strRange As String
'...later on in the function:
strRange = strRange & Sheets(gstrFilename).Cells(lngRow, bytCol).Row & ":" & Sheets(gstrFilename).Cells(lngRow, bytCol).Row & ":"
Range(Left(strRange, Len(strRange) - 1)).Select
thanks in advance!