| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to imput " " (quotes) in to your cells
Hi there,
I'd like to input " " (quotes sign) in to cells as string, for example "Hello there", how to do this through VBA? Also, I also want to input "=" (equal sign) into the cells too. How to do this. Thanks Lee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to imput " " (quotes) in to your cells
Hi
activecell.value=""" """ -- Regards Frank Kabel Frankfurt, Germany "Lee" schrieb im Newsbeitrag ... Hi there, I'd like to input " " (quotes sign) in to cells as string, for example "Hello there", how to do this through VBA? Also, I also want to input "=" (equal sign) into the cells too. How to do this. Thanks Lee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to imput " " (quotes) in to your cells
Demo'd from the immediate window:
Activecell.Value = """Hello there""" ? activeCell.Value "Hello there" to put double quotes in a string, use two double quotes. If you want to put a formula in a cell ActiveCell.Formula = "=Sum(A1:A10)" -- Regards, Tom Ogilvy "Lee" wrote in message ... Hi there, I'd like to input " " (quotes sign) in to cells as string, for example "Hello there", how to do this through VBA? Also, I also want to input "=" (equal sign) into the cells too. How to do this. Thanks Lee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| MSN stock quotes - Error message "problem displaying attributes" | Excel Discussion (Misc queries) | |||
| "MSN MONEY STOCK QUOTES" NOT OPENING IN 2002 | Excel Worksheet Functions | |||
| "formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Linear Mode
