Bottom left part of the UsedRange
The csv file I import in my previous post contains two rows of informational data followed by a blank row followed by the real data. I needed to determine this range to loop though.
I decided to make a function and this is what I cam up with.
Feel free to shoot at it….
Function DataRange(tmpWorkSheet As Worksheet) As Range Dim rTemp As Range Set rTemp = tmpWorkSheet.UsedRange.Columns(1) Set rTemp = rTemp.Cells(rTemp.Rows.Count, 1) Set rTemp = rTemp.CurrentRegion Set DataRange = rTemp End Function