Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Select multiple adjacent cells of multiple cells without selecting

1 view
Skip to first unread message

sjsjsjsjsjs

unread,
Dec 18, 2009, 2:33:01 PM12/18/09
to
Select multiple adjacent cells of multiple cells without selecting adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Thank you for your help.

Don Guillett

unread,
Dec 18, 2009, 3:38:45 PM12/18/09
to
Adjacent in this case, means?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"sjsjsjsjsjs" <sjsjs...@discussions.microsoft.com> wrote in message
news:99297A76-87C0-45D7...@microsoft.com...

sjsjsjsjsjs

unread,
Dec 18, 2009, 5:40:01 PM12/18/09
to
Adjacent in this case, means?
some characters cells that's adjacent of A cells.

Thank you for your help.

"Don Guillett" wrote:

> .
>

sjsjsjsjsjs

unread,
Dec 18, 2009, 5:44:01 PM12/18/09
to
I am trying to select some characters cells that's adjacent of A cells
without selecting some characters cells one by one.

Thank you for your help.

Don Guillett

unread,
Dec 18, 2009, 6:07:31 PM12/18/09
to
Examples or send your file with a COMPLETE explanation

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"sjsjsjsjsjs" <sjsjs...@discussions.microsoft.com> wrote in message

news:7004C678-E1A0-4E33...@microsoft.com...

Gord Dibben

unread,
Dec 19, 2009, 4:05:45 PM12/19/09
to
Do you want to select or just return the values if they match "A"

=IF(B1="A",A1,"none") entered in C1 and copied down.

Maybe??


Gord Dibben MS Excel MVP

sjsjsjsjsjsjs

unread,
Dec 20, 2009, 10:54:01 AM12/20/09
to
those cells looks like;
|Column A |Column B|
|random characters | Y |
|sjsjsjsjskkskskskk | Z |
|wtwuwuwuuusisis | Y |
|wuuuuusiwuwuwiu| Y |
|euuuuuuuuuuuuuuu| Z |
.
.
.
.
continue...
I am trying to select A cells that's adjacent of Y cells without selecting A
cells one by one, then
copy selected cells to Column C, and
keep rows of selected cells.
those cells will look like;
|Column C |
|random characters |
| |
|wtwuwuwuuusisis |
|wuuuuusiwuwuwiu|
| |
.
.
.
.
continue...

Rick Rothstein

unread,
Dec 20, 2009, 10:30:28 PM12/20/09
to
You do know you have some answers to this question over in the
worksheet.functions newsgroup where you also posted this question. For
future questions... please post them in one newsgroup only and then check
back to see the answers you get there.

--
Rick (MVP - Excel)


"sjsjsjsjsjsjs" <sjsjsj...@discussions.microsoft.com> wrote in message
news:423705C3-AAA0-47BE...@microsoft.com...

sjsjsjsjsjsjschanged

unread,
Dec 23, 2009, 3:22:01 PM12/23/09
to
Thank you for your help.
Macro really worked.
re you working for Microsoft or have ou ever worked for Microsoft?
Did Microsoft ever publis A Super Input Routine?
my search in microsoft websites doesn't show any of information about book.

Rick Rothstein

unread,
Dec 23, 2009, 3:43:58 PM12/23/09
to
I'm glad the macro worked out for you. Something you may want to consider
with it. As it stands now, If you run the macro twice, it will leave its
previous display in Column C and just add the new items to them... if you
would rather get rid of the previous runs information so you can just see
the current run's items, add this line to the macro immediately after the
first If statement...

Columns("C").ClearContents

That will clear out Column C before displaying the new run's information.

--
Rick (MVP - Excel)


"sjsjsjsjsjsjschanged" <sjsjsjsjsj...@discussions.microsoft.com>
wrote in message news:329361D5-88AD-44F8...@microsoft.com...

Rick Rothstein

unread,
Dec 23, 2009, 3:52:08 PM12/23/09
to
Sorry, I forgot to respond to the second part of your question. No, I don't
work for Microsoft, nor did I ever work for them. I, like the other regulars
here on the newsgroups volunteer our own personal time to answer the
questions that get posted here. We hope that whatever past experiences we
have had with Excel will prove to be useful in addressing those questions.
As for the MVP designation you will see on some of the volunteers here,
perhaps this link will help you out in understanding the our relationship
with Microsoft...

http://mvp.support.microsoft.com/

As to your last question, exactly what would you expect to be in a "Super
Input Routine"?

--
Rick (MVP - Excel)

"sjsjsjsjsjsjschanged" <sjsjsjsjsj...@discussions.microsoft.com>
wrote in message news:329361D5-88AD-44F8...@microsoft.com...

sjsjsjsjsjsjschanged

unread,
Dec 23, 2009, 8:09:01 PM12/23/09
to
input routine for Excel, and publisher of book and seller of book.

Thank you for your help.

0 new messages