![]() |
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