ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formatting Cell Ranges (https://www.excelbanter.com/excel-programming/341563-formatting-cell-ranges.html)

turnerje[_4_]

Formatting Cell Ranges
 

I would like to use VBA to have excel select a specific range, and the
format it for a specific date format (3/14/2005). I am running Offic
2003. Many thanks in advance.

Justi

--
turnerj
-----------------------------------------------------------------------
turnerje's Profile: http://www.excelforum.com/member.php...fo&userid=2569
View this thread: http://www.excelforum.com/showthread.php?threadid=47208


Tom Ogilvy

Formatting Cell Ranges
 
Range("B9:F33").NumberFormat = "m/d/yyyy"

--
Regards,
Tom Ogilvy

"turnerje" wrote in
message ...

I would like to use VBA to have excel select a specific range, and then
format it for a specific date format (3/14/2005). I am running Office
2003. Many thanks in advance.

Justin


--
turnerje
------------------------------------------------------------------------
turnerje's Profile:

http://www.excelforum.com/member.php...o&userid=25694
View this thread: http://www.excelforum.com/showthread...hreadid=472088





All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com