Sorry, I'm really, really ignorant when it comes to programming macros.  I
currently have an Excel file with two worksheets.  Worksheet 2 is named
"Links" and consists of a list of links (not in hypertext format... not sure
of this could be the problem or not).  Sheet 1 is named ...

I work for a company that typically has very large and long
engagements. Many reports/schedules/analysis spreadsheets are created
throughout obviously. Each case usually has its own custom headers/
footers specific to that case. Although they can change numerous

how do I supress the warning when deleting a sheet with a macro?  I am using
the command following command to delete the sheet.
Sheets("Sheet1").Delete

I need to add the same cells in multiple worksheets. I want the worksheets
to be selected dynamically using a range on another worksheet which contains
the names of the worksheets to sum. I don't want any formulas in the summary
worksheet - I want to populate the cells with ...

This works great -
If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then ....
I need the same statement, but "not empty" - been searching, but can't find
it!

I have a list of prefered words for specific type work sheets, is there a way
to force a user to select from that list and only that list?
In my workbooks, each sheet will have a column (F) that will use up to 29
rows maximum.  When ever a user selects a cell in that column I want ...

I was about to embark on moving some VLOOKUP type code into a VBA module
using the "WorksheetFunction" approach.  First however, I thought I'd check
whether there was an easier, more direct approach.
Following my nose, I find the VBA development help system provides a list of

SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26)
It will not allow and giving error of #VALUE
Please help!

I am trying to saving a file based on the text name in a designated cell in
the workbook.  However, with this code, I get an “subscript out of range”
error.   Do you know what I am doing wrong?
Thanks for your help.

I am trying to saving a file based on the text name in a designated cell in
the workbook. However, with this code, I get an “subscript out of range”
error.  I am running out of ideas.  There must be a way to do  this!  Seems
to be problem with variable.

I have a worksheet with 30 worksheets. I would like to color each tab
a different color for reference purposes. I can't figure out how to
wright a macro to select a sheet and then select a tab color.
This is my macro to select each worksheet. How can it be modified to

I am trying to make a "simple to use" way of generating buy-requisitions and
reccording the individual purchases in a table.
Each requisition will have 1 to 20 lines (rows) and each line will consist
of 12 cells. 2 of the cells are keyed in manually the rest are generated (

Is there a way to import a string into a label on a userform?
Thanks

How do I pass the variable "vData"?
'======
   lRow = Range("A1").End(xlDown).Address
   'MsgBox lRow 'for testing

I would like to know how to create a Macro in Excel (Maybe something better),
that would automatically go to "Sheet1" Cell A5 at the launch of Excel.  
Currently I have
Sub Auto_Activate()