This code will select all the cells in the specified span relative to the starting cell if they contain data (or any other criteria you want).
Private Sub selectRangeWithData()
Dim startCell As Range
Dim dataRange As Range
Dim rowSpan As Integer, colSpan As Integer
Set startCell = Range("A7")
rowSpan = 200
colSpan = 52
'initialize the first cell of the selected range
Set dataRange = Range(startCell.Offset(1, 0).Address)
'loop through the supplied range and determine if data exists
For Each cell In Range(startCell.Offset(1, 0), startCell.Offset(rowSpan, colSpan)).Cells
If cell <> "" Then
'if so, add it to the range
Set dataRange = Union(dataRange, Range(cell.Address))
End If
Next cell
'finally, select the range of cells
dataRange.Select
End Sub