This will be "fun" to describe so it makes sense...
At the spreadsheet level (no VBA on this part) I have used Insert:
Name: Create to create names for several rows and columns of a table.
For instance, row names dog, cat, skunk; column names smellsgood,

I have set up a macro to print  several worksheets in a Excel workbook.
How do I omit a sheet fom printing if it reflects a zero value in a certain
cell

I have created a user form with several buttons - how can I lis
something from a worksheet into that userform so it is displayed nex
to one of the several buttons
--

I have created a Listbox on a Userform. the Listbox properties are a
folows:
Name: SectorList
MultiSelect: fmMultiSelectMulti

Can someone tell me what is wrong with this code?  I get an
application/object defined error on the 2nd row.  Am trying to insert a sumif
formula into a cell, to add only those cells that do NOT have the word "MES"
in them.  

Im trying to write a macro to search for text in multiple worksheets, and
then delete that entire row - can anyon help please, it would be much
appreciated....
Thanks

Hello Guys, I have the following task...
Code:
--------------------
   Task 4

I am looking to create a spreadsheet for myself and some friends who
need an easy way to manage finances. Also, I don't feel like springing
the cash for Quicken. So, I am planning on creating a spreadsheet with
VBA code windows and messages to manage the data more effeciently.

I have a monster formula I could not place on one line of code so I had
to split it on to two lines but now when I run the code it comes up with
out of memory error!
Any ideas on how to tackle this problem?

I've been having a real (tho stupid) problem w getting Auto_Activate to work
with sheets in my Workbook.
I create a name within an active sheet (say Sheet1) called "Auto_Activate".
I refer the name to a procedure (say OnActivate) that I have written within

I do not know if this is possible, but if someone knows how to do it,
will be grateful.
So the problem is that i want to show a picture when a value i
negative, and another when is positive, can i do it?

Hi, just had to re-install Windows & also re-installed Office 2003 & now
all Spreadsheets containing Macros don't run, user pages don't open???
Any idea's
Thanks for your

-I also have a cell that lists the Total Income, which i name GSI
-I also have collumn listing Expenses and at the bottom, sums the total
expenses, which iname TOTAL_EXPENSE
-Lastly, below that, i calculate the Net Income by subracting the

I am having a problem with a spreadsheet.
Basically i have 4 cells each having numbers in it. What i want is for
each cell to show a percentage and not a number.
Ie.  Cell 1    Cell 2     Cell 3     Cell 4

That's great Gary and exactly what i am looking for.  However i am have
one difficulty doing this.
i click on the cell named "EXPENSE_TOTAL", got to menu
Insert->Name->Define.  Find the EXPENSE_TOTAL name, remove the "$" has