hello,

I would like to change the format of a column but I do not want to
select it, do you think it is possible to do something like this

Columns("C:C").NumberFormat = "yyyy/mm/dd"

Ina

I use the column number like this:

Columns(i).NumberFormat = "yyyy/mm/dd"

where i = column number

Die_Another_Day

exactly.

--
Regards,
Tom Ogilvy


"ina" wrote:

hello,

I would like to change the format of a column but I do not want to
select it, do you think it is possible to do something like this

Columns("C:C").NumberFormat = "yyyy/mm/dd"

Ina

thanks :)