Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling gives me error 424
Hi,
I have a macro. The code in the macro to select the list of info is like this: Dim varRange As Range Set varRange = _ Application.InputBox("Select the range of Tests", Type:=8) On Error GoTo 0 If IsObject(varRange) = False Then Exit Sub The error that i get is weird. When the user selects the row without scrolling on the sheet, the macro just runs fine. But when the user selects the list of info after scrolling on the sheet for a few seconds then a run time error pops up which is like this: Run time error 424: Object Required. I am unable track what gives this error when the user makes his selection after scrolling to the right or left. Can someone please help on this. Thanks Abhi. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- smooth scrolling (instead of 'snap' scrolling) | Setting up and Configuration of Excel | |||
Vertical scrolling...jumps rather than smooth scrolling | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
Input Box error when scrolling | Excel Programming |