New to Excel VBA, but have 10 years programming in Access
I have a row pointer for my worksheet, and a command button on a form that I
want to use to insert a blank row after the currently selected row, and then
copy the data from the first three columns of the currently selected ...

I have a pivot table/pivot chart that has three dropdowns for the Page, Row
and Column.  I need to make some format changes to the chart any time the
user changes one of them.  Is there some event I can capture so that my code
will run when a change is made?

I have a worksheet with 24 columns and 940 rows. I need the ability to
occasionally insert a new row at various spots in the worksheet.
So what I need is something which will insert 1 row at the point the curser
is located, maintaining the same formats as the cells above. ...

I am trying to create a report page similar to what Acess does, however I do
not know how to use Acess, so I want to do it in Excel. My vision is to
programmaticlly take all my rows of data and paste it onto a report, using a
userform selection as my filter criteria and here is ...

My worksheet has 3 columns and 493 rows of data. For example
         COL 2       COL3    COL4
Row1 0840600     2219      text
Row2 0840625     1345      text

Is there a limit on the comma delimited list for Data Validation in Excel
2007?
I know that it was 255 character limit per cell in previous versions of
Excel, and I found that new number of characters that can be stored in a cell

Win XP Pro Ms Office 2003 Professional
I want to protect an work sheet with hidden columns that has cost
information I want to hide from my customers but just found out that if
I copy the spreadsheet and paste it into a new workbook, the protection

I have built a macro that will take a clipart picture and post it to a
spacific cell in my worksheet.  This is so that the formular used in that
cell will make the macro show the proper picture.  I have built on the
worksheet a pictable and names the table.  BUT the thing will ...

I am a macro newbie so bear with me... what I'm trying to do in this macro is
be able to take all the information in a series of worksheets and compile it
into one master worksheet. I want to be able to edit and add things to the
individual sheets, and with the help of a macro, ...

I have an excel 2007 spreadsheet that uses a Visual basic and sql to
populate.  The procedure runs fine on all machines except two
machines.  The program passes through one parameter and then clears
the work sheet and populates.  The problem seems to be when the

Can anyone tell me how to write the string of code to stop a macro at a
certain point? I have the following macro that runs through a range but
because I need to use the cell.find and activate mode when it loops around it
ignores the range and continues on, I am thinking if I could ...

My macro just stops execution without any error message as if it encountered
an END statement. It does this at the line     ActiveSheet.Name =
"Paste_Buffer"
   On Error Resume Next

Hi All.....
I would like to alternate the row color from gray to none, for each group of
rows according to the value in the cells in column G.  That is, starting with
row 11, I want no background color, then if G12=G11, likewise  row 12 would

I am a novice to intermediate user with vba. I have two worksbooks, one that
contains the assignment data and the other that contains the raw data.
assignment book (file A)
fields - workQ       (col A)

Hi'
Hope you can help.
I need to lookup a collection of textstrings in a specifik range - and
then react if the textstring is found: