View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] michael_mcclellan@hotmail.com is offline
external usenet poster
 
Posts: 23
Default If (starts with ', then delete the ')

Gentlemen (and Ladies),

Unfortunately the last person who did this job entered dates with a "'"
in front of all of them, and excel will not recognize them as dates.
I'm looking for some code that will do the following:

rownum = 7

Do
if Range("P" & rownum).Value [begins with "'"] then
[delete the "'"]
rownum = rownum + 1
Does anybody know how to do something like this?