I have read multiple threads here regarding speed issues and xl2007.  They
all have said that it has to do with charting or lack of SP1.
So what if I don't create charts with my code, and have installed SP1?  I am
still experiencing a 50% slowdown.  I've found that it somehow has ...

I use some wide spreadsheets which get printed out landscape on A3
paper in order to track student progress in multiple subject areas.
Each row is for an individual student.
At the minute I highlight alternate rows (ctrl-clicking) and then set

I have recently migrated data from one excel sheet to another.  However it
is now required to protect all the migrated sheets.
I wish to do this via code rather than go into each sheet and protect.
I have opened each sheet with code and used the following code :

I want to pass a column character as parameter to subroutine. What
should I define it as? Also how can I use that inside subroutine?
For example, the API the subroutine should look like is as below:
formatColumn("C") - Should format column C as per defined in the

I'm having a problem testing for a blank cell with conditional formatting.
I'm looping through a range of cells and when I get to a cell that I know
should evaluate to TRUE for having met the conditional format it is returning
false.  The conditional format is when cell value is ...

I have a data range called Benefits.  This range does not include the header
row - that is a seperate range named BenefitHeader. The data looks something
like this:
Name               Owner   Terminated        Var1

I just finished my project with Studio 2008, Excel 2007, and C#. I read a csv
file, parse the data, and enter it into a formatted excel spreadsheet.
I just learned that it's going to need to be functional for all versions of
excel after 97, however.

I have two cells (J2) and (T2) both have formulas in them.  Can I use
conditional formatting to color T2 if it is less than J2

Please help,
I am formatting each page to print using vba and it is very cool but slow
with 75 tabs / pages to format.
I can select all tabs (with vba) and manually format all selected tabs but

I currently have frames in a userform to separate different types of controls
to make it easier to read for the user.  The problem is they kinda take up
too much space.  Is there a way I can draw a line to separate the controls
instead of a box like a lot of dialog boxes in ...

How do I Remove Columns with header in row 1 but no data in remainder of
column?
I am using exported template spreadsheets that provide the header row ready
for data import to the spreadsheet then using this to do bulk import to SQL

  I have a purchase order template which has a bunch on vendor
information on sheet 2, while the actual purchase order form is on
sheet 1.  I have a button on screen which is called "create PO".  When
I press this button, the program re-names the worksheet as PO-

I'm trying to figure out how to navigate from a textbox that contains a
comment object back to the worksheet cell that the comment is associated
with.
The case begins with the user selecting the comment textbox

I have 2 differnt fields for my page - I want to set one to a user enter
value and the other to "ALL" items. I have tried the following
       pvt.PivotCache.Refresh
           pvt.PivotFields(str_selection_value1).CurrentPage = str_selection

I am having some difficulty setting pagefields and values -- here is my
code...
           strpivotsheet = "Pivot Table"
           str_selection_value1 = "Delivery #"