try:
Sub foo()
With Range("a:a")
.Formula = .Value
End With
End Sub
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Rita Palazzi wrote :
Windows XP Professional
Office 2000
I've got text in an imported column. There is an apostrophe at the
beginning of every cell. Is there a quick easy way to remove the
apostrophe from all cells?
Thanks in advance for any help!
Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express