View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Pete McCosh[_6_] Pete McCosh[_6_] is offline
external usenet poster
 
Posts: 1
Default Help Please Cut/Paste Macro for DVD Subtitles

Pock,

this is what I meant about text wrap, these two lines should be
written in the VBE window as one line without the underscore ("_")
character. When I reply on the MS site, it has a very narrow text
window. The code should read:

Cells(LastTime,3).value = Cells(LastTime,3).Value & "<p" &
Cells(x,3).value


Pete

Pock wrote in message ...
Pete,

Thanks a ton for your response. However, when I tried your code, the
following line wouldn't compile:

Cells(LastTime,3).value = Cells(LastTime,3).Value_
& "<p" & Cells(x,3).value

It seemed to get stuck after the ampersand. Forgive me for my lack of
coding genius. I took out the spaces but that still didn't help.

Any suggestions?

Thanks,
Pock

--------------------------------------
remove I_hate_SPAM_ from my address
when sending me an email

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!