Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #2185
| From | vincentmax <vincentmax@foxmail.com> |
|---|---|
| Subject | Re: Error Excel AdvancedFilter method in VBScript |
| Newsgroups | comp.lang.basic.visual.misc |
| References | <1118161851.370403.254090@g14g2000cwa.googlegroups.com> |
| Message-ID | <08adnYR6vps2BPnJnZ2dnUU7-d-dnZ2d@giganews.com> (permalink) |
| Date | 2014-11-13 05:44 -0600 |
I think the code should be like this:
XL.Range("A1:A22").AdvancedFilter xlFilterCopy,,XL.Range("F1"), True
missed XL in the parameter
Back to comp.lang.basic.visual.misc | Previous | Next | Find similar | Unroll thread
Re: Error Excel AdvancedFilter method in VBScript vincentmax <vincentmax@foxmail.com> - 2014-11-13 05:44 -0600
csiph-web