Use of Double quotes in VBA IF Statement

  • Thread starter Thread starter steveski
  • Start date Start date
S

steveski

I want to test a field to see if it is empty. In a spreaadsheet, I can
use double quotes, but in VBA it doesn't work. Can you help?

Target(1, 5).FormulaR1C1 = "=IF(RC9="","","Not Empty")"
 
And from a tip by Tom Ogilvy:

Dim myStr As String
myStr = "=IF(RC9=@@,@@,@Not Empty@)"
myStr = Application.Substitute(myStr, "@", Chr(34))
ActiveCell.FormulaR1C1 = myStr
 
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

VBA error - End If without Block If 2
Code takes to long to process Excel 2007 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
The code below worked for a few days and just totally stoppedworking. What can I do to make sure it 1
VBA insert comment only when cell in a range changes first time 5
Unable to assign FormulaR1C1 correctly 3
How to chain VBA applications 5
Looping in a range 3

Back
Top