Changing cells based on content

**BAC240SX** · 09-19-2006, 05:49 PM

How can I get an excel macro to change a selected column's individual cell content based on that cell's content. For example, if have a column with either e or c in each cell I want the macro to change the c's into 0's and the e's into 1's.

Is that possible? How would I go about doing that?

**colofnature** · 09-19-2006, 07:22 PM

Please Login or Register  to view this content.

HTH
Col

**BAC240SX** · 09-19-2006, 07:58 PM

That worked almost perfectly! Is there anyway to have the macro work on the selected column instead of having to edit the macro every time?

or

I just thought of somethings else...does "with [a:a]" mean column A through column A? Would "with [a:c]" mean column A through column C? I could just copy and paste it over and over again with the exact columns I need correct?

-- BAC240SX

**colofnature** · 09-19-2006, 09:25 PM

Yup, that's exactly right, [a:c] is shorthand for Range("A:C"), columns A thru C, so "With [a:c]" would apply the Replaces to the three of them.

Or, to answer your first question, "With Selection.EntireColumn" would apply them to the whole columns in which cells are selected - however many cells are selected, even if they are not contiguous, so you could select A1, D4 and Q73, if you wanted, and it would work on the whole of columns A, D and Q.

C

**BAC240SX** · 09-19-2006, 09:45 PM

Thanks buddy! That was what I wanted, only, now the idea of selecting all those columns seems tedious (I know I'm lazy, but isn't that the point of a macro, and we are talking about a hundred or so columns)

Is there a way to have the macro select a range of columns, say for example "with [a:z]" but exclude columns b, g, and y?