I'm trying to get help from the Microsoft VB Editor Help and once I do a
search, some of the subjects that come up bring up the detail normally but
some don't. I want to get help on commands I can use in my macros but I'm
stuck. Can someone help me? PLEASE

I have a macro in Excel that calls a macro in a Word document with this code:
           wordApp.Visible = True
           wordApp.Activate
           wordApp.Run ("myMacro")

I have created a macro that adds rows with the formulas from the previous
row.  This will work perfectly for people wanting to add rows within a
'section'.  Now I would like to have a macro that add's a new 'section' which
is basically just a new row that is a different colour to ...

I just wanted to post here that this newsgroup is AWESOME... I posted a
question/response and got immediate and fantastic assistance - especially
from Ron de Bruin who has just been extraordinary in first posting the
original code and then  helping me through all my questions and ...

when I set a rowsouce of a dropdown, I hope there are two columns one is
shown and the other is hidden just like the old game we play in other places.
How can I do it in the dropdown control's property window.
Clara

The trouble with having programmed for a long time in one language is that
your thought system for design constantly works along the same routes. Here
is a simple Case statement...
               If dblSubTotal > 0 Then

I am very new to VBA, but I have quite a bit of experience in Excel.
I have data in multiple cells on one row of a spreadsheet that I need
to extract and place on multiple rows (in a new worksheet).  My
situation is this: I get a "daily sales report" with one row for each

I'm trying to compare the values in 2 ranges and if found, copy the
entire row to a new worksheet.
This is what I've come up with but it's not working:
'----

I have created a formula that generates about 1000 numbers and i need them to
filled into empty cells on another worksheet. For example:
The number is generated in sheet1 cell A13
I need that number to be placed in sheet 2 in the first empty cell, range

I was wondering if anyone can help me with some code to dynamically place a
border on the last row of a spreadsheet.  The issue for me is that the
spreadsheet varies in length (based on filtering), but the columns are static
(A:S).  What I was hoping to do is place a border on ...

After extensive modifications to the general menu that Ron de Bruin has,
I've decided to try my hand on the xml/Ribbon.
I've downloaded the files/programs that're recommended.
the xml editor from MS.

Maybe I shouldn't get too deep into this.  Maybe it's just a moon
phase or something.  I opened up my workbook this morning and all the
values returned by a Function were showing #VALUE errors.  I went over
everything carefully, making sure it was picking up the correct values

I have some worksheets (questionnaire format) for each of the client. The
client name, phone number and other information are at the same locations in
each worksheet. My question is how I can create a summary sheet, so that each
row in the summary sheet contains one client ...

I am trying to assign labels to the tickmarks on a chart in an Excel module.  
I have the following code:
label = "all the same"
For Each tick In chtObj.Chart.Axes(xlCategory).CategoryNames

Added new VBA routine to Excel 2000 file which caused termination of Excel.  
The message occurs even if disable micros or when saved as a csv file.  Any
other options to be able to open the file and correct the faulty VBA code?