Cannot get the values of cells in a loop

Hello,
I don't know if anyone can help. I am trying to see the values of the cell when looping, but it is on showing the value of the first cell only. Can you guide me on what I am doing wrong? Thanks in advance.

Code below
'Convert Column F to corresponding name in colmn A
xlSource.Activate()
xlSrcSheet = xlSource.Worksheets("sheet1")
xlSrcRange = xlSrcSheet.Range("A1")

'xlSrcRange.Select()

For i = 1 To xlSrcSheet.UsedRange.Rows.Count
xlSrcRange.Offset(i, 0).Select()
'code goes here
xlSrcRange.Select()
Debug.Print(xlSrcRange.Value.ToString)
Debug.Print(xlSrcRange.Cells.Value.ToString)
NexT

Welcome to the forum.

Just a note: Read Rule #3 of the forum rules about adding the code tags.

EDIT:

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:


Code:
your code here ...
and here ...
and hereYou can also type the code tags in manually if you prefer. For more information about these and other tags, click here.