Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use a conversion function in a whole column
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use a conversion function in a whole column
On Mon, 28 Jul 2003 01:46:49 -0700, Terence wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV Column Conversion | Excel Worksheet Functions | |||
Row to column conversion | Excel Discussion (Misc queries) | |||
Perpelexing Row to Column conversion | Excel Discussion (Misc queries) | |||
PV function conversion to SQL | Excel Discussion (Misc queries) | |||
Excel Column and row conversion | Excel Discussion (Misc queries) |