Datatype of Range for VBScript

**TheBrigg** · 01-26-2012, 11:47 AM

Hi Everyone,

I have a very simple question and I cannot seem to find the answer anywhere. What is the datatype of a "Range" in Excel when I need to declare it in VBScript?

e.g.
_{VBA:

Dim sRange as Range

Set sRange = blah.Cells(x, 1).EntireRow

VBScript:

Dim sRange

Set sRange = blah.Cells(x, 1).EntireRow / Type mismatch

Or

sRange = blah.Cells(x, 1).EntireRow / Object Required}

**Kyle123** · 01-26-2012, 11:49 AM

Have you created the application object first?

**TheBrigg** · 01-26-2012, 12:54 PM

I found the issue I was having, but thank you for the reponse. For others who may run into the same problem, my error handling was bugging. The problem was in a separate bit of code that was checking the sRange value before attempting to assign a value to it, making sure it was empty.