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
Last edited by TheBrigg; 01-26-2012 at 12:37 PM.
Have you created the application object first?
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks