Selecting Range of Cells based on Criteria

[gmclauchlan]

Hi,

New member here.

I'm looking for a solution for to be able to select a range of cells based on the yes/no value in another cell in the same row.

Cells A12, A13, A14, etc will either have a yes/no value. Based on the cell having a yes value, I'd like to select cells B12:M12, B13:M13, etc.

I have been able to workout how to do the select but not based on criteria.

Any help or direction would be greatly appreciated.

G

[Charles]

gmclauchlan,

Welcome to the forum. In your request are you wanting to select the range for each "Yes" on 1 row or are you wanting to (when you use the filter and select Yes) select the "Visible" range of information? Also what do you want to do with the selection?