I managed to get on the forum where the link below was originally posted and ask if someone there can figure out what its not doing correctly for me. So, please disregard these post on this subject. If I get an answer, I will post here for everyone to see. Thanks, Steve
--- In ExcelVBA@yahoogroups.com, "sspatriots" <sspatriots@...> wrote:
>
> I've found the following:
>
> http://www.mrexcel.com/forum/showthread.php?t=284013
>
> However, I tried running it and it turns all the cells in the specified range the color of the condition, even all the cells don't meet the conditions. It also colors the empty cells that were previously not colored. I'm hoping somebody can tell me what I can do to the code in the link above to make it work. I have no idea where to start on something like this. Thanks.
>
>
> --- In ExcelVBA@yahoogroups.com, "sspatriots" <sspatriots@> wrote:
> >
> > 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
> >
>
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
----------------------------------
Tidak ada komentar:
Posting Komentar