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

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