Hi

I have some code which is returning a starting point and end point for cells
which contain data or formulas in a spreadsheet. I want to limit this to
only cells which display data. My formulas concatenate data from an input
sheet but display "" on lines in which no data has been entered on the input
sheet.

With ActiveSheet.UsedRange
StartRow = .Cells(1).Row
StartCol = .Cells(1).Column
EndRow = .Cells(.Cells.Count).Row
EndCol = .Cells(.Cells.Count).Column
End With

I believ it is the UsedRange element that needs changing but I'm unsure what
it needs to be replaced with.

Thanks