0

I'm just trying to write the following out in an excel cell using VBScript.

What I want in the cell:
=BDS(A2,$B$1,"dir=H")

I'm having problems with excel accepting the quotations for some reason

this is what I have and is getting an error with:
""=BDS(A"& LC &",$B$1,"dir=H")""

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by Marcel_Go
0

change the quotes you need in the sheet by chr(34) and use only the quotes where you need them in your program. If you need "this is an example" (with the quotes) in excel you have to script : chr(34) & "this is an example" & chr(34).

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.