Franklienovice
New Member
- Joined
- Jul 16, 2011
- Messages
- 2
I am using Windows XP with Excel 2007, I am a complete novice to VBA and am trying to find a script that will help me to do the following<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o> </o>
I have a large excel file that has multiply columns, and 1729 rows, I want to do the following, <o></o>
Programme a commandbutton to unhide a sheet called “Info” then clear any filters they may be in place, then to go column “I” which contains lines <o></o>
Similar to the below<o></o>
<o> </o>
AMBER 187432<o></o>
ANTICIPA 475482 <o></o>
ANTIPODES 077241 B<o></o>
APP UN 177174<o></o>
ARABELLA 1305 C<o></o>
ARABELLA 1305 L<o></o>
ARABIAN 133631 <o></o>
ARCTIC 190321 <o></o>
AZURA 201126 <o></o>
BELLA 141608<o></o>
BIANCA 201362 <o></o>
<o> </o>
And filter it looking for all lines with say ie “APP 177174”<o></o>
<o> </o>
Then I want to have another commandbutton that removes the filter , hides the sheet called “info” and returns to the original page ie “Front page”<o></o>
thank you in advance for any help you can give me
Franklienovice
fficeffice" /><o></o><o
> </o>I have a large excel file that has multiply columns, and 1729 rows, I want to do the following, <o
></o>Programme a commandbutton to unhide a sheet called “Info” then clear any filters they may be in place, then to go column “I” which contains lines <o
></o>Similar to the below<o
></o><o
> </o>AMBER 187432<o
></o>ANTICIPA 475482 <o
></o>ANTIPODES 077241 B<o
></o>APP UN 177174<o
></o>ARABELLA 1305 C<o
></o>ARABELLA 1305 L<o
></o>ARABIAN 133631 <o
></o>ARCTIC 190321 <o
></o>AZURA 201126 <o
></o>BELLA 141608<o
></o>BIANCA 201362 <o
></o><o
> </o>And filter it looking for all lines with say ie “APP 177174”<o
></o><o
> </o>Then I want to have another commandbutton that removes the filter , hides the sheet called “info” and returns to the original page ie “Front page”<o
></o>thank you in advance for any help you can give me
Franklienovice
