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: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=515405

Sub AddText()
For Each cell In selection
cell.Value = "cell.value & "more text"
Next cell
End SUb

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"superkopite"
wrote in message
...

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:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=515405

Thanks a lot Bob

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

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=515405

so there was, sorry about that.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"superkopite"
wrote in message
...

Thanks a lot Bob

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

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=515405