How to imput " " (quotes) in to your cells

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

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
 
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)"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to do double quotes in "cell language"? 4
Fade text in a cell, disappeared when we input new text. 1
Requiring Cell Input 1
display $ sign in excel sheet 2
How to refresh an Excel workbook from VBA 2
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2
random range of cells via cell names 3
No characters data in Hyperlink cell 3

Back
Top