PC Review


Reply
Thread Tools Rate Thread

Adding formating

 
 
jln via OfficeKB.com
Guest
Posts: n/a
 
      7th Nov 2006
Im trying to add formatting that goes to the last row and makes it bold and
formats the numbers to currency. Help

--
Message posted via http://www.officekb.com

 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      7th Nov 2006
With Range("A1").End(xlDown)
.Font.Bold = True
.NumberFormat = "$#,##0.00"
End With

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jln via OfficeKB.com" <u25956@uwe> wrote in message
news:68ef7d31a1e69@uwe...
> Im trying to add formatting that goes to the last row and makes it bold

and
> formats the numbers to currency. Help
>
> --
> Message posted via http://www.officekb.com
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding More Conditional Formating november678x Microsoft Excel Programming 6 7th Mar 2006 09:03 PM
Word Formating & Words Adding =?Utf-8?B?S2VsdmluIExlZQ==?= Microsoft Excel Misc 1 28th Nov 2005 04:33 PM
Adding percentages in a column and automatic formating of contents =?Utf-8?B?RlRQ?= Microsoft Excel Worksheet Functions 3 17th May 2005 06:14 PM
adding 00 or 0 not by formating the cell, but ... kath Microsoft Excel Worksheet Functions 2 26th Aug 2004 04:50 PM
adding and formating a new drive, need help Glenn Kenney DIY PC 7 20th Dec 2003 11:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:24 AM.