Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding subtitles to chart title | New Users to Excel | |||
Cut and Paste Macro | Excel Discussion (Misc queries) | |||
how do i split subtitles in a single cell? | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |