Looping stops at first cell, not the last cell.

[AB33]

First, this is not my macro; I have got from somewhere. I would like the result of tmpText to appear next to column “A”, i.e. in Column “B”, on each cell. I am sure I made a mess of it on these lines, but could not work out why.

Please Login or Register  to view this content.

I get a value on Range(“B8”), but if I change this line

Please Login or Register  to view this content.

In to

Please Login or Register  to view this content.

I would like to get values from cells 1-8. Please see attached.

[patel45]

Please Login or Register  to view this content.

[nilem]

maybe so

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[AB33]

Patel and Nilem! Both worked
Thanks very much for your time and skills!