is their a way to rename wordart instead fo it having the defaul name of say
wortart 345
regards

i have a sheet which among other things contains 3 coloum of images, the idea
of the images is that once clicked they activate a macro which runs asking
the user 4 questions , the macro then pastes the data into a preset area (in
the same row as the button and then deletes the ...

I'm half way there with this.
From the top.
I have the below code which tags the value of frame1 as row1, Ok so
far.

    Is there an easy way to concatenate two cells??
  Suppose the worksheet has six cells like this:
Row 1: John Smith
Row 2: Dick Jones

I have a table of data.. with one column including 'types' i.e. bursdag
In another sheet I want to list all the unique types in this table, one
on each row. How can I make a macro to do this?
I would like it alphabetical...

Recently everytime I open any Excel Workbook I get asked to load my XP
professional disk, but I only have XP Home can anyone help.
Regards
Subs

I'm using a form to maintain a data list in Excel and the list box click
event sets the scroll bar value to its index even when the click event hasnt
even happed, infact the only way to change the scrolbars value is to click
on the list box, If you click on the scroll bar it must ...

Good day,
I would like to know where to place my code, since placeing it in the module
section produces an error. The code is seen below. I need this code to
execute for the "current displayed" worksheet, but I do not believe that I

The following code is misbehaving and throwing up an error 1004.
************
Sub match_add()
Dim v1 As Date, r1 As Range, m1 As Variant

All -
I have several macros that each input and parse a lot of data and then
format the result. Each takes a long time to run.  I watch that
hour-glass for a good while, but the macros in the end do successfully

I hope someone can help and I hope I’ve been clear. Thank you in advance for
your advice.  It is much appreciated.
If cell A4 is a particular month (mmm)  or my calculation in that field is:
=text(date)(year)(now()),month(now()),0),”mmm”

Hi...
I have a 32 sheet workbook that my users input quite freely. However, when
they have completed their input I want to hit a button that will freeze all
data and refuse any more changes/user input. I'd use protect workbook but the

I'm new to comboboxes and need a few clues.
I have Combobox1 that lists 3 dates.  Combobox2 lists the names of
volunteers.
I want to be able to make many selections from combobox2 to produce a LIST

Just wondering if anyone can help me with this.  I have a file template that
is linked to another template's new book.  The template is paperwork.xlt and
the link is to paperwork1.  If I use the edit links in the toolbar the change
link works.  My macro works when the link is to ...

Hey All,
I have a problem with a code i am trying to use. This code,
SUMPRODUCT(--(ISNUMBER(FIND(C2,$A$2:$A$200,1))),--($B$2:$B$200=B2+5)),
does not help me in solving a problem i am trying to solve. This is the