Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object required - run time error 424.
Set rArea = Application.InputBox(prompt:="Select range:", Type:=8)
Set rXValues = Application.InputBox(prompt:="Select XValues:", Type:=8) Set rYValues = Application.InputBox(prompt:="Select YValues:", Type:=8) It worked fine. Now it reports the error in subject to me. Sometime VBA crashes on the 1st instruction, sometime on the 2nd. Thanks, Alex. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object required - run time error 424.
If you click cancel, then you won't return a range and your set statement
will produce that error. Harald Staff gave you some sample code in a previous post. -- Regards, Tom Ogilvy "devorivivere" wrote in message ... Set rArea = Application.InputBox(prompt:="Select range:", Type:=8) Set rXValues = Application.InputBox(prompt:="Select XValues:", Type:=8) Set rYValues = Application.InputBox(prompt:="Select YValues:", Type:=8) It worked fine. Now it reports the error in subject to me. Sometime VBA crashes on the 1st instruction, sometime on the 2nd. Thanks, Alex. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object required - run time error 424.
I always selected the range with my mouse and the clicked OK.
I never closed the msgbox with the "X" at upright position. Tom Ogilvy wrote: If you click cancel, then you won't return a range and your set statement will produce that error. Harald Staff gave you some sample code in a previous post. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object required - run time error 424.
And I have never gotten this error using code similar to Harald's.
-- Regards, Tom Ogilvy "y" wrote in message ... I always selected the range with my mouse and the clicked OK. I never closed the msgbox with the "X" at upright position. Tom Ogilvy wrote: If you click cancel, then you won't return a range and your set statement will produce that error. Harald Staff gave you some sample code in a previous post. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error ....object required | Excel Programming | |||
Run-time error '424': Object required | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Dget in VBA gets Object required run-time error? | Excel Programming | |||
error 424 - Object Required | Excel Programming |