Super Easy Question -- "

  • Thread starter Thread starter kaon
  • Start date Start date
K

kaon

Hi all,

I want to display "N/A" whenever the denominator is zero and I wrot
such code:

Cells(c, col).Formula = _
"=IF(" & Cells(c, j + 1).Address & "=0, "N/A", ("
Cells(c, j).Address & " - " & Cells(c, j + 1).Address & ") * 100 / "
Cells(c, j + 1).Address & ")"

However, I do not know how to tell Excel that some " are escap
character, anyone that can teach me?

Thanks
 
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

Modify working code to expand the output. 5
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Counting Criteria Values with For Loop 3
Excel 2003: macro to add data to next empty row 3
Macros and empty cells 2
Cut bottom 300 rows to next sheet & repeat 8
Find string from column A in Range("B2:F7") list the header of that column/s 5
Sub runs, but gives error when called. 7

Back
Top