I have a large named range on my worksheet and want to have my code inspect
every cell in the first and last row only and NOT ispect every cell.

How can I modify my code to inspect the first row cell values?

Dim DataCell As Range
Dim FieldName As Name

For Each FieldName In ThisWorkBook.Names
If Not FieldName Is Nothing Then

For Each DataCell In Range(FieldName) 'Loops thru all names
Debug.Print "cell: ", DataCell.Cells.Value
Next DataCell

Endif
Next FieldName

thanks.