[ExcelVBA] Covert Conditional Formats to Permanent Formatting

 

Hi,

I have a worksheet where there are conditional formats set up to use "Italics" based on the contents of an adjacent cell and "Shaded Cells" during a particular date range on the calendar. I want to be able to create a snap shot of this worksheet and put it in a new workbook attached to an e-mail. I have code that will do everything I want, except I don't want the conditional formatting carried over. I'd like for those conditinal formats to be converted to hard formatting. I tried recording and pasting values, formats and you name it, but nothing would work. Any help would be greatly appreciated.

Thanks,

Steve

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___