Member Avatar for jcb0806

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
  • 130 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by Marcel_Go
Member Avatar for Marcel_Go

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).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.