column format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snowing - 31 May 2006 20:14 GMT

Hey,

I have a macro that does a bunch of stuff, but before it does that
stuff I want it to format a column which holds a date value, I want it
to format the columns cells so that the date format is m/d/yyyy h:mm
Does any one know how I would go about this?

Signature

snowing

Reply to this Message

Matt Lunn - 31 May 2006 20:29 GMT

> Hey,
>
> I have a macro that does a bunch of stuff, but before it does that
> stuff I want it to format a column which holds a date value, I want it
> to format the columns cells so that the date format is m/d/yyyy h:mm
> Does any one know how I would go about this?

If the macro only refers to one worksheet. Use the macro recorder and record
the formatting you apply to the column. Copy the code it creates into your
main macro. If the macro jumps from sheet to sheet you may need to modify
this code accordingly.

HTH

Reply to this Message

Die_Another_Day - 31 May 2006 21:11 GMT

> Hey,
>
[quoted text clipped - 8 lines]
> snowing's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34576
> View this thread: http://www.excelforum.com/showthread.php?threadid=547201

Columns("A").numberformat = "m/d/yyyy h:mm"

HTH

Die_Another_Day

Reply to this Message