inserting quotation marks

[dave glynn]

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.

 

[Bob Phillips]

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]

Thanks Bob

Kind regards

Dave

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)