Re: [ExcelVBA] Formatting with Macro

 

Is there anything in excel to do the equivalent of "paste value" for formats?

To condense conditional formats just to their present cell format state?

Any deprocation of the version of excel from say excel 2003 to 1995
that strips the logic off but leaves the cells formatted bold, grey,
underlined or whatever? Export out (save as with yes yes yes!) to
this version and open the slimmed down workbook resave to the later
version?

The penscratchings of the worlds worst VB scripter

Dr B

On 13/04/2012, sspatriots <sspatriots@yahoo.com> wrote:
> Hi,
>
> I have several worksheets in a workbook that currently have conditional
> formatting to shade adjacent cells in the range F2:J20001 if there value is
> less than a number in the adjacent cells in column B. For example, if cell
> H33 has the number 9.898 in it and B33 has the number 10, then I want H33
> shaded.
>
> I would use conditional formatting for this, however, I have a subsequent
> macro that copies these worksheets to another workbook and I don't want all
> the conditional formatting to go with it. I just want to copy the values and
> the formats to the new workbook. While I realize there is code out there
> that shells out to MS Word using HTML and then back to Excel, it is really
> slow. If I copy the conditional formatting to the new workbook, the file
> size is huge. Any help would be greatly appreciated.
>
>
> Thanks,
>
> Steve
>
>
>
> ------------------------------------
>
> ----------------------------------
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>

--
Sent from my mobile device

===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

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

Messages in this topic (6)

Recent Activity:

• New Members 3

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

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

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

.

__,_._,___