Select multiple adjacent cells of multiple cells without selecting

[sjsjsjsjsjs]

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]

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.

 

[sjsjsjsjsjs]

Adjacent in this case, means?
some characters cells that's adjacent of A cells.

Thank you for your help.

 

[sjsjsjsjsjs]

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]

Examples or send your file with a COMPLETE explanation

 

[Gord Dibben]

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]

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...

Thank you for your help.

 

[Rick Rothstein]

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.

 

[sjsjsjsjsjsjschanged]

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.

Thank you for your help.

 

[Rick Rothstein]

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 Rothstein]

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...



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

 

[sjsjsjsjsjsjschanged]

input routine for Excel, and publisher of book and seller of book.

Thank you for your help.