I'm a newbie to excel automation and could do with some guidance. I'm
trying to set cell values using variables within office 2007 but the
only method I can find to set values is via "Range" - and I can only
appear to specify Range values if a column header is specified: eq. A2.

If I put an "On error resume next" command in a macro, and it's in a
sub called from another sub, does it end when the sub it was in ends,
or does it still apply back in the parent sub?
TIA

I have  a sheets with charts whose series, for example, go from A3 A11
(X) to B3 B11 (Y), another chart ranging from A6A11(x) C6C11 (Y) and so
on..
Everytime I add a row of data I manually have to add the new point to

I am a relative novice at VBA programming but here goes...
In Excel, I am trying to fill a combobox ("ComboBox1") in a user form
("inputBox") through a dynamic named range in the "MasterDataSheet"
worksheet of my workbook.  The dynamic named range is named

I have a problem that's been plaguing me for a while now.
I have a fairly complicated Excel (97) Workbook made to
create html pages (it's a template for generating html in
effect).  The root of the problem is that list boxes and arrays

How would I write the code to hide only rows that do not have bolded items
in column K ...

I need to search through the Named Ranges in a sheet and for the ones
that contain certain text, in this case "IMP" then I need to set a
conditonal format to the range.  I have the conditonal formating part
working but Im having trouble iterating through the names for the text

anyway to set a userform name to a variable i can use with <variable name>
instead of with userform1, with userform2, etc?

I am trying to record a macro wherein I would just unprotect the sheet,
correct a small error in a formula and then protect the sheet.
I start recording, I unprotect the sheet, I correct the formula and the
moment I press ENTER i get an error "Unable To Record"

I have a form that has a number of pages on it.
How can I select which page to display when the form is opened?
TIA

I am making a userform and I cant think how to get this to work.  I am
trying to add textbox2 value to textbox3's  ie 2 + 6 = 8
Here is the code I am using.  Sorry I have a bit of brain fade.
TOTPEGS.Caption = TextBox2.Value + TextBox3.Value

I would like to export my excel worksheet to xml.  For example, my
excel data looks like this.
Color    Grade
Red    A

I want to be able to drag a label (or other suitable control to act
like a box) on a userform at runtime.
I have written the following to do this but have these problems:
1) the movement is quite jerky - at times the label can even jump

It would be very nice if SheetsInNewWorkbook was one of the arguments for
the Workbooks.Add procedure.
Maybe I can do this somehow through my PersonalMacros Addin?
Best regards,

I am currently writing a macro for Excel and I have hit a problem.
Here is my working Macro code.
Sub dialight()
   Range("B1").Select