How to use a conversion function in a whole column

[Terence]

Hi,

I would like to apply a conversion function, e.g. Cstr(),
to the values in the whole column ,e.g. Column A (Start
from cell A2 since A1 is the column heading). How to do it?
Thanks a lot!

Terence

 

[Sander Lablans]

Hi,

I would like to apply a conversion function, e.g. Cstr(),
to the values in the whole column ,e.g. Column A (Start
from cell A2 since A1 is the column heading). How to do it?
Thanks a lot!

Terence

count1 = Application.WorksheetFunction.CountA(Columns(1)) - 1

range("A1").activate
for i = 1 to count1
activecell.offset(i,1).value = cstr(activecell.offset(i,0))
next i

Good luck