How to use a conversion function in a whole column

  • Thread starter Thread starter Terence
  • Start date Start date
T

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
 
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
Click to expand...

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
 
Back
Top