Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tom Ogilvy:Object Error Still
Hi Tom,
Everytime I run this code it never picks up on the query, it always comes back and says it can't be found. I attempted to Debug using the Step Into and when it gets to Set rng = sh.Range(RngName), I get sh.Range(RngName) =<Application-Defined or Object-Defined-Error, Rng = Nothing and also Method "Range" of Object "_Worksheet" failed. It does get the iqy file and then strips of the last 4 characters to give the range name but for some reason this is all that happens, it just goes on to display that it wasn't found. (Just a note, all of my queries are in Sheet2). Could you take a look, I would really like to get this working. Thanks for all your help and time!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Tom Ogilvy | Excel Worksheet Functions | |||
Thank You Tom Ogilvy | Excel Worksheet Functions | |||
Tom Ogilvy - Request for follow-up on previous help offered | Excel Programming | |||
to Tom Ogilvy: re Macros in excel | Excel Programming |