I have a worksheet named "List" that contains data (text and numbers) in
column A.  I'd like a macro to create a new tab with the name equivalent to
the value of cell B6 on the worksheet "List" and based on a worksheet called
"Template".  The data in column A of "List" needs to ...

I'm working on a macro-loaded Workbook (that's shared via a SharePoint
site), and every time I open the workbook, make some changes, then do
a simple save (Ctrl+S, or File->Save), it works fine, but any macro I
try to run from a list on the Menu bar

I need some advice on this task.
I have a listbox with 21 items. When I click onto an item, I want a unique
userform to display - for that item - with additional parameters for the user
to click.  So each item brings up its own additional userform.  Now I am

Hi all.  I've got a vlookup formula on a spreadsheet with relative cell addressing that my macro copies when appropriate. I want to retain that formula but concatenate " For Serial Number 12345" so that appears in the cell.
sSerialNum is the variable. Here's my (failing) approach:

I'm currently trying to optimize this macro for use with more than
30,000 rows.  I thought by jumping from one ID to another it would
help but it still takes a considerable amount of time to run.  Any
thoughts or tips are greatly appreicated.  I have listed a sample data

Attached is my currect macro is adding two characters in the front would it
be possible to add three characters in the back also?
Sub Goodman2()
Const Summaryworkbook = "GOODMAN OPEN ITEMS.xls"

I've been looking in here, and can't find what I'm looking for.
So.....
A macro within a workbook Original List 4-20-07.xls, will open up
anothe workbook,

I want to create a spreadsheet that looks at multiple criteria to determine
the likelihood of something occuring.  Specifically, a= 1,2,3,4 or 5, b<=
100,200,300,400,or 500 and c <= 10,20,30,40,50.  Given these criteria, what
are the probabilities that a random number generator ...

Is it possible to create characters in Excel?
If so how is it done/
Ed

I have four merged blocks in a row on a worksheet as follow:
BCDE     FGH      IJ     K->T
I set rng to the first block's range whose addressi B1 then
I use rng.offset(0,1) to jump to the second block and I did it, but when I

I have a form which opens in Excel that allows users to display/hide tabs.  
There’s 60+ tabs so the form allows them to see only the ones they want.  The
form contains a series of check boxes that they check, then click on a
display/hide button, and hide the tabs that are not ...

How can I delete all the rows which column "E" doesn't contain the
character "|" with an Excel macro?

I have a excel with pivot table but the data source of the pivot table is
some other excel which is not given to me. I need to read the original data
(i.e. unpivoted data) from it. Is there any way... I have no clue about.
Can any one provide me some pointers.

I have a field in a pivot table named "PC GROUP" with an item named "DSD".  I
am wondering if there is a way to programmatically determine if DSD is
currently a  hidden (or visible) item.
Thank you for your help.

I have a program that has rs.addnew as one of the first lines of code, even
if there are no records to be added.  When exiting Excel, an error comes up
that states "memory counld not be written."  I believe it is because I cannot
perform an rs.Close command because rs.Update is ...