|
-
March 29th, 2001, 03:21 PM
#1
VBA error
Hi all,
I have the following VBA code in the macro for my Excel SpreadSheet, but the macro is giving an error " RunTime error '1004', Application-defined or object-defined error".
I am on Win2k, MS-Office2K.
Range("B3").Select
Selection.QueryTable.Refresh BackgroundQuery:=false
The error points to the second line i.e. "Selection..."
I would also add that I am a newbee to VB, my strengts lie elsewhere. This was needed to transfer some upload some data to the spreadsheet
TIA
Ajay K
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|