(Msg. 1) Posted: Mon Aug 18, 2008 11:06 am
Post subject: Selecting Cells Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Hello another question for the excel guru's, again thanks in advance for your
help.
I have a list of values in column Q, I have a formula that identifies values
which I am interested in selecting.(The row is identified when column Q has
the text "Sums to ")
I need a macro which will select only the identifed rows so i can then
copy,delete or move them.
(Msg. 2) Posted: Mon Aug 18, 2008 1:25 pm
Post subject: Re: Selecting Cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Have a look in the vba help index for FINDNEXT.
OR,
use data>filter>autofilter>filter on col q
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1.TakeThisOut@austin.rr.com
"Terry" <Terry.TakeThisOut@discussions.microsoft.com> wrote in message
news:92824DA6-42C3-4120-A655-C27362D258D8@microsoft.com...
> Hello another question for the excel guru's, again thanks in advance for
> your
> help.
>
> I have a list of values in column Q, I have a formula that identifies
> values
> which I am interested in selecting.(The row is identified when column Q
> has
> the text "Sums to ")
>
> I need a macro which will select only the identifed rows so i can then
> copy,delete or move them.
>
> Thanks,
>
> Terry
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office