I have a button on a worksheet created from the Forms toolbar.  I'd like to
display a dialog box if this button is clicked but am having trouble showing
the dialog box from a subroutine in a module.  Can anyone point me in the
right direction?

I have a group of data that is in A1:K10,000.  The data is sorted by
item numbers, which are in A.  I would like to have the code go
through and color code the changes.  So if Item one is in A1:A14, I
would like this to be one color.  Then on A15:A18 which is a different

I want to get list of all possible permutations when conditions defined. For
example, I have a word "ABC". And I need the list of permutations when two
letter is taken at a time.
AB

I have a column of data.  Most of the cells are blank, but the ones
that are not I would like to Offset(2,2) and paste the formula from
Q4.  I would like to do this a bunch of times and was thinking for
next and loop it.  If there is an easier way I woudl be all ears.

How do you delete all the 'names' defined @ workbook? I can only do it 1 at
time now using 'Insert'-'Name'-'Define'......however, I have hundreds of them
(accumlated unknowingly, when I copied 3rd party worksheet - it seem that the
names juz get copied over each time you copy ...

I am merging selected recipients from an excel document to labels. Everything
from selection of recipients to final merged label document appears
fine...but there's always info. missing.  Problem is Label Sheet has 16
individual labels, but 17th recipient is always missing, the ...

What do I need to do if I have a spreadsheet that is read only? I need to
autosum and run a macro... Oh yeh it says it is password protected... any
takers on this??

If I conditionally formated cells in worksheet that contain specific text to
have a fill color red, how can I get the rest of the cells in the same
row/rows (for the entire worksheet) to match that cell fill color?

Hi from Aussie
I have the following formula however only the first two requirements show up
- anything under 12 continues to show the "Warning" sentence - What am I
doing wrong please?

I am trying to append "lbs" to the value in the cell, but this does
not seem to work.
Any help is appreciated.

I'm highlighting two cells in the same row, hitting format cells, alignment,
merge cells and I'm getting the error message, "The selection contains
multiple data values.  Merging into one cell will keep the upper-left most
data only."  I want to be able to make the two seperate ...

I need a formula that keeps a running count of characters in a cell.
Any help would be appreciated

I have a large workbook with a lot of links to different files (with
same layout).
I am looking for a way to check if the formula's in a column are all
linked to the same file or folder.

I'm using WRAP TEXT but the data in the cell is truncated.  I can see the
entire entry in the formula window, but not in the cell.

The results of the following formula is 0 when column G has values in it.
=SUM(IF($B$6:$B$65536="John Doe",IF($B$6:$B$65536="Jane
Dane",IF($B$6:$B$65536="Jack Dark",IF($G$6:$G$65536<>"",0,1)))))
Can someone please show me what I am missing or don't need in the formula in