I'm trying to make a procedure in Visual studio for looping through a range not named into Excel. For example the user selects "A1" & "A5" "A94". In my procedure I can see the range.count prorperty as value 3, but if I make a Do Loop I can't take the second cell value of the selected range but I find "A2". My procedure is this: I'm trying to make a procedure in Visual studio