Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Apply format to certain worksheets in workbook

Posted on 2013-11-04
1
Medium Priority
?
334 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 1200 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In this post we will learn different types of Android Layout and some basics of an Android App.
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
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…
Simple Linear Regression

609 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