ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Scrolling gives me error 424 (https://www.excelbanter.com/excel-programming/294242-scrolling-gives-me-error-424-a.html)

Abhi[_3_]

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.



All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com