Hello,
when I use in my code:
it adds pattern and KEEPS BACKGROUND COLOR of modified cells. OK...
Please Login or Register to view this content.
But when I use in my code:
It removes the pattern but IT ALSO REMOVES BACKGROUND COLOR. Which is not OK for me.Please Login or Register to view this content.
MANUALLY, via cell properties, IT IS POSSIBLE to remove pattern and keep background color by selecting top-left pattern style.
Is there such solution for VBA?
Thanks for your replies.
You need Color as opposed to PatternColor.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Ok, to be more specific: I have following very simple (quickly written) "enhancement" macro to help me with orientation in Excel sheets:
which works fine until I start to use workbooks with colored cells (which is not so often in case of "data-output workbooks" compared to "office workbooks", but...). If you test it, it will make my needs clear.Please Login or Register to view this content.
If you test it, it will make my needs clear.
Test it with what? You want me to create a workbook, put the code in, guess at what steps you go through to colour some cells and then see if I can break it. I don't think so.
OK, I don't want you to do anything. I just would like you or anyone to answer my unsolved question:
Is it possible to remove cell pattern by a simple instruction and to keep (formerly set) cell background color?
Regards.
Short answer would appear to be "no".
I've asked for others to take a look.
I know, therefore easy quick solution with borders (for workbooks, where borders are not used):
Bye and thanks.Please Login or Register to view this content.
It has been suggest that you use Conditional Formatting rather than pure VBA. You will, however, still need a small piece of code to enable the functionality.
See the solution suggested here:
http://www.tushar-mehta.com/publish_...d%20cell.shtml
Regards, TMS
Also interesting. Thanks. But I have to move on in my work... my solution is for me enough (followed by easy code to remove all borders from workbook on closing...)
Regards.
As you wish. Good solution provided you don't use borders in your workbook. Which I guess you don't otherwise you'll probably face the same problem over again
(It is being used only in workbooks without any formatting (prg output data, originally as CSV) and cells in these wbks are already conditionally formated (highlighting of deviations for further presentation as pre-analysis). And browsing through such excels at 50% zoom on 24" high-res LCD is sometimes little bit difficult, when I try to find and visually compare corresponding data on the same row or in the same column - there are approx.70 columns and xx000 rows. Therefore I added 2 lines to the code above making the borders red...).
OK, the thread solved for me.
Best regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks