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.