a learner
a learner
Programming language:Whatever
2021-08-28 02:58:29
0
Q:

use " inside strin vba

Tammy Treit
Tammy Treit
Code: Whatever
2021-07-23 01:13:26 
'Method 1
Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0,"""",Sheet1!A1)" 

'Method 2
Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0," & CHR(34) & CHR(34) & ",Sheet1!A1)"
0

Tags

Related

New to Communities?

Join the community