I have used the below macro to insert page breaks in a report where it is
possible to hide different rows.
The problem is, that the macro counts all rows in the specific range whether
they are hidden or not.

Is there a way to set up a spreadsheet so if a certain condition is
met, a comment box will pop up asking for feedback.  For example, if a
machine is running at less than 90% capacity, I'd like a comment box
pop up or a row to open up below the 90% to give room for the user to

I had a macro to hide some columns on the end of a report.  They keep
changing the columns on the right so I changed it to automatically count to
the last column and now I get a syntax error.  THANKS!
Public Sub HideXtraColumns()

I have the following code in my work book. It does exactly what I want it to
apart from each time a value is changed and the code runs the code scrolls
back through the entire sheet and as the number of rows is getting quite
extensive now this can take some time.

I have my cells format in a sheet as European date (dd/mm/yyyy - UK).
When I typed the date in or used the code, cells(1,1) = #12/31/2006#,
to input the date, it converted very well.  Cell A1 will show
31/12/2006 and it is a date value.

My problem is I am trying to create a formula that would calculate some
figures.
FORMULA: -
IF D15 is equal to D17:D20 display result, IF not display result

I need to run a subroutine depending on the value of a validation list.
Currently I use Worksheet_SelectionChange to see if the validation list
was entered from another cell and that works. However I have the need
to run subroutines where a specific subroutine is run depending on ...

Thanks for this error handler macro.  I have one question about it.  It is
for a user form.  
Where it says "exit sub" , what is the exit sub for?  The end sub is the end
of the subrouting which it reaches if there is no error, but if there is an

When working in VBA I try to add the Microsoft Common Dialog Control to my
toolbox but when I try to use it I get a message box telling me "The Control
Could Not Be Created Because It Is Not Properly Licensed".  I tried searching
the Microsoft Knowledge Base and Found a utility ...

hi,
I have the following:
TextBox3.Value.Format = "$#,##0.00"
I am trying to format the UserForm field to have zero decimal places, and

hi,
I am trying write code to determine if a specific value, lets say "DOODLE"
exists within a specified range in an excel sheet.  The range specified could
be J12:J88 for example.

I have created a program using VBA and I am attempting to use a form
for my first time.  I want to have a checkbox that when checked allows
users to input additional items into the form.  by default I want the
box to be unchecked and those input boxes grayed out and disabled.

I have numerous workbooks and every day the latest worksheet has to be
copied and the date changed on the tab (with most recent always on the
left).  The procedure is right click on tab, move or copy, create a
copy, right click, rename to prior business day.  The dates are not

I want to delete rows
ie one row that has a certain no in a certain column like 1 in column A
and the next 6 rows that follow
my problem is that this repeats itself many times in the excel sheet

Does anyone have a sample ODBC connection string to connect to a table
on the IBM AS/400. This is not using client access but the ODBC driver
that comes with Excel.
Any ideas?