software

Hiya guys and gals,

How can I create a Macro that when i select a range of sells will add a
predifined text to the end of the text already in each selected cell.

I konw this is possible and have tried lots of variants of code, all
turning out to be incorrect.

Kind Regards

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=515405Sub AddText()
For Each cell In selection
cell.Value = quot;cell.value amp; quot;more textquot;
Next cell
End SUb

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; Hiya guys and gals,
gt;
gt; How can I create a Macro that when i select a range of sells will add a
gt; predifined text to the end of the text already in each selected cell.
gt;
gt; I konw this is possible and have tried lots of variants of code, all
gt; turning out to be incorrect.
gt;
gt; Kind Regards
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515405
gt;

Thanks a lot Bob

There was an extra quot; in there but when i removed it it worked
fantastically

Cheers

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=515405so there was, sorry about that.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; Thanks a lot Bob
gt;
gt; There was an extra quot; in there but when i removed it it worked
gt; fantastically
gt;
gt; Cheers
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515405
gt;