Solved

Apply format to certain worksheets in workbook

Posted on 2013-11-04
1
298 Views
Last Modified: 2013-11-04
I need to be able to apply conditional formats to certain sheets in an excel file.
This is what I have:

Open in new window

Dim vSheets As Variant
Dim wb As Workbook

Set wb = ThisWorkbook

vSheets = Array("Referrals", "MessagesLeft", "ServiceLevel", _
        "RPC_NoPTP_NoReferral_Cnt", "RPC_NoPTP_NoReferral_%", "Download", "Attempts", "DialerConnects")
For Each vSheets In wb.Worksheets

Variance
Next vSheets
0
Comment
Question by:DCUnited
1 Comment
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 300 total points
ID: 39621600
I assume that variance is a sub. You can have something like

vSheets = Array("Referrals", "MessagesLeft", "ServiceLevel", _
        "RPC_NoPTP_NoReferral_Cnt", "RPC_NoPTP_NoReferral_%", "Download", "Attempts", "DialerConnects")
For Each vsheet In vSheets
wb.Worksheets(vsheet).Activate
Variance
Next vsheet
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question