Why does Excel add question marks to numeric values in a range? How to fix?

[OaklandJim]

I am doing a super basic For Loop through a range of numeric values. I did do Format Cells => Number, no decimal points to make sure that the values are numbers. When I Debug.Print the numbers there are question marks after the numeric values. What might I check?

Here is a truncated version of my formula that causes the issue.

Function DoTheForLoop(piQty As Long) As String
    
    Dim rAnchorCellCapacity As Range

    Dim rLookUpRange As Range
    
    Dim rCell As Range
   
    Dim iDataRows As Long
   
    Set rAnchorCellCapacity = [Data].Range("Header_Capacity")
    
    iDataRows = rAnchorCellCapacity.Offset(10000).End(xlUp).Row - rAnchorCellCapacity.Row
    
    Set rLookUpRange = rAnchorCellCapacity.Offset(1).Resize(iDataRows)
    
Debug.Print "rLookUpRange = " & rLookUpRange.Address
        
    For Each rCell In rLookUpRange

Debug.Print rCell.Value

    Next rCell
    
End Function

Debug.print output looks like this

rLookUpRange = $D$7:$D$11
36?
60?
72?
96?
120?

 

[OaklandJim]

After looking at values' TypeName I get string. I reentered the values and now they are Double. I suppose that the issue is fixed.

 

[Mario_R]

Hello. The origin of the data: Is it a Web page?...