set a range for a variable Bex

Guys,

I am just trying to set a range for a variable below is a example.

Varialbe :

Technical Name Value

ZCSO_INDUS

101_MNTH 01/2013 - 05/2013

ZSO_SOD

ZSO_SHP 80159371

Code :

Set RANGE1 = Sheets("sheet1").Range("A1:B4")

Run "BEXanalyzer.XLA!SAPBEXsetVariables", RANGE1

Run "BEXanalyzer.XLA!SAPBEXrefresh", True, RANGE1

It doesn't work, someone give me an exaple to give a variable range.