I have a sheet with about 38 columns and 600 rows. I need to have a comboBox,
list, form, etc where a user can select a category (I have 15 categories each
with 20-100 rows of data) and the sheet will populate the 38 columns with
only that category's data. What's the best way to ...

I have a range of rows with data withi them. say 100 rows. on the
sheet theres acell in which you enter a number say 20.  And the
program deletes all the rows within the range except the first 20, I
am using a very simple code at the moment but i am sure could be done

When I click on form1 (execute button), I close form1 and open a form2 which
indicate a process bar and there is a Cancel button to stop the macro. When I
click on it, the macro continue to run. Is there a way to stop the macro?
Thanks!!

Executing the code given below throws an error:
"Microsoft Office Excel has encountered a problem and needs to close.  We
are sorry for the inconvenience."
But If I remove first insertLine statement that is ".InsertLines LineNum,

I am saving an array of three sheets from with in a workbook.  It will go
through all the process of asking name and everything like that but won't
save the file.  Here is the macro that I am using .... any help would be
appreciated.  Many thanks

I have a form with multiple comboboxes where names can be selected,
all driven from a common array filled from a range on a hidden data
sheet.  What I'm trying to achieve, and probably just missing
something really simple, is management of what happens when a name

I have two workbooks in a folder on my desktop.  I want to copy from one
workbook to the other workbook.  It tells me it cannot locate the file.  It
did run once but I have not been able to get it to run again.  I have tried
the path various ways with no success.  Have I missed ...

I had some macro ( Modifty Header and Footer , Add Menu , Delete
Menu )
My macro will change the footer and header, and, pre-set issuer inside
macro.

Having some success but stuck with checking values in several columns.  The
below was taken from Ron de Bruin's web site (which is great I must add) but
I can't get the code to delete rows where the criteria matches.  Also, once
sorted, is there an option to do the same but us OR ...

I need your help !!
Any idea how to disable in VBA all menus in EXCEL 2007?
On the top of that I need to hide also the main title on the top with Excel
+ name of the file appear - so it doesn't look Excel any more

I have a little problem,  I have a list of values open in one
workbook, and another list of value in a second open workbook.  What I
need to do is loop through each of the values with the first list, if
the value appears on the second list I then wish to delet the entire

I would greatly appreciate your help in finally being able to add a
varible range in my macro.
I am creating three pivot tables in my report.
I am running the report weekly.

I refer to the highly informative link below:
http://j-walk.com/ss//excel/usertips/tip080.htm
I am trying to develop a VBA function procedure that will run along a
row of 12 cells (one for each month of the year) and perform a simple

Excel 2003, Sp2
Hi
I want to track changes in cells made by the user in the workbook. I use the
Workbook_SheetChange event.

Been a long while since I posted on here!
Does anyone know how to look at a textbox, and see if at least one of
the letters is uppercase?
Basically I need to try to recreate microsofts password complexity doo-