Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Qn: How to Append???
Hello Everyone,
I am trying to "cut and paste" my schedule from the internet into my Exel Worksheet. Then, I am trying to import it to my Calendar in Microsoft Outlook. It will NOT import unless I prefix all my data with a ', So, is their a routine that I can write that will take a column of data and append prefix it with a '. Example: Data now: Cell 1A: IND Cell 2A: LAS Cell 3A: MDW Cell 4A: FLL I need the cells 1A:4A look like this: Cell 1A: 'IND Cell 2A: 'LAS Cell 3A: 'MDW Cell 4A: 'FLL Could somebody help me with this??? Thanks.. mv |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Append???
sub AppendChar()
Dim cell as Range for each cell in Range("A1:A4") cell.Value = "'" & cell.Value Next End Sub -- Regards, Tom Ogilvy "Michael Vaughan" wrote in message ... Hello Everyone, I am trying to "cut and paste" my schedule from the internet into my Exel Worksheet. Then, I am trying to import it to my Calendar in Microsoft Outlook. It will NOT import unless I prefix all my data with a ', So, is their a routine that I can write that will take a column of data and append prefix it with a '. Example: Data now: Cell 1A: IND Cell 2A: LAS Cell 3A: MDW Cell 4A: FLL I need the cells 1A:4A look like this: Cell 1A: 'IND Cell 2A: 'LAS Cell 3A: 'MDW Cell 4A: 'FLL Could somebody help me with this??? Thanks.. mv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you append one row to another? | Excel Worksheet Functions | |||
Append worksheets together in one | Excel Discussion (Misc queries) | |||
append row | Excel Programming | |||
open for append | Excel Programming | |||
Compare and Append | Excel Programming |