Hi
I have a macro that copies 31 worksheets into one master sheet. In the 31 worksheets I have some conditional formatting. I would like my macro to copy the resulting colours of the conditional formatting ( but not the formatting rule) to the master work sheet. Is this possible?
I have researched this but not come up with an answer.
Thanks
Terri
Please Login or Register to view this content.
Try this
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Wow Arlu you are so clever. It works, it works . You're a star . Thanks so much.
Am glad its solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks