inserting quotation marks
 

I want to insert quotes in front of text in 1280 cells that already have
values in them. Is there an easy way to do this with a macro.

Select those cells

Dim cell

For Each cell In Selection
cell.Value = """" & cell.Value
Next cell


--

HTH

RP
(remove nothere from the email address if mailing direct)


"dave glynn" wrote in message
...
I want to insert quotes in front of text in 1280 cells that already have
values in them. Is there an easy way to do this with a macro.

Thanks Bob

Kind regards

Dave

"Bob Phillips" wrote:

Select those cells

Dim cell

For Each cell In Selection
cell.Value = """" & cell.Value
Next cell


--

HTH

RP
(remove nothere from the email address if mailing direct)


"dave glynn" wrote in message
...
I want to insert quotes in front of text in 1280 cells that already have
values in them. Is there an easy way to do this with a macro.