LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default how to copy font settings

Anybody know how to write a vbscript that can copy font setting like size or
color from sheet1 to another sheet. Both sheets have the same information
on it so that if you change the font size on cell B2 on sheet1 the
corresponding cell on sheet2 would be the same. Hope this make sense and
somebody knows how to do this. Thanks for all your help.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: Keeps applying auto-font settings I don't want Seb Thirlway Excel Discussion (Misc queries) 1 April 1st 10 04:01 PM
how do I change default settings for Comments (its font, etc.) bromm Excel Discussion (Misc queries) 1 April 16th 07 11:01 PM
Change permanantly default chart settings like colour, font.. utopian_sorceror Charts and Charting in Excel 2 September 19th 05 06:41 AM
Comment Box Font Settings armenthj Excel Discussion (Misc queries) 1 March 3rd 05 07:09 PM
Font settings in Excel Rachel gigi Excel Programming 0 July 20th 04 02:58 PM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"