vba code clear cells by color font dark blue

**etheer** · 12-10-2012, 03:43 PM

Hi
I need vba code clear cells by color font dark blue in sheet1 sheet 2 sheet 3

**JOHN H. DAVIS** · 12-10-2012, 04:12 PM

Maybe:

Please Login or Register  to view this content.

**etheer** · 12-10-2012, 05:06 PM

Thank you so much

code work 100% but when change name sheets do not work run time erorr 9

name sheets in my project

sheet6 TDL
sheet9 ACCOUNT
sheet10 ACCOUNT2
sheet11 ACCOUNT3

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 12-11-2012, 08:10 AM

Try:

Please Login or Register  to view this content.

**etheer** · 12-11-2012, 09:06 PM

Thank you
work code but in sheet3 do not work run time erorr 9

**JOHN H. DAVIS** · 12-13-2012, 08:03 AM

Try:

Please Login or Register  to view this content.

**etheer** · 12-14-2012, 08:26 AM

Thank you code work

**JOHN H. DAVIS** · 12-14-2012, 08:29 AM

You're welcome. Glad to hear that and thanks for the feedback. Please comply with Rule 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.