select one cell above specific text

[raj soni]

hi ,
i am trying to select all cells in single column above specific text : "team members"
plz note: there are many cells in same column having word : team members ,
so i want to select each one of them at same time .

[sintek]

Hi raj soni

Please explain ....

i am trying to select all cells in single column above specific text : "team members"

Then you say...

so i want to select each one of them at same time .

So...
Do you want to select all the cells that say team members or...
Do you want to select all the cells above team members...

[raj soni]

all the cells above team members...

[leelnich]

Hi all- Try this. (Change the column to suit):

Updated 26-JUL-2017 06:45. reason: fixed double-select of first instance

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[raj soni]

perfect thanks , also can you look @
https://www.excelforum.com/excel-pro...med-range.html

[sintek]

...........Deleted.............