Macro Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 20 Sep 2006 00:24 GMT

I don't know very much about coding macros at all so I was wonder how I
would get one to change the content of a selected column's individual cells
based on that cell's content. For example, if have column A 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 it possible to do something like that?

-- Bryan

Reply to this Message

Gord Dibben - 20 Sep 2006 00:48 GMT

Bryan

It is possible but a Macro is not needed for this. Worksheet function will do
the job.

In a "helper" column enter =IF(A1="c",0,IF(A1="e",1,"neither"))

Drag/copy down as far as you need.

Gord Dibben MS Excel MVP

>I don't know very much about coding macros at all so I was wonder how I
>would get one to change the content of a selected column's individual cells
[quoted text clipped - 3 lines]
>
>-- Bryan

Reply to this Message

Dave Peterson - 20 Sep 2006 01:14 GMT

You could also select the range and do a couple of edit|replaces.

Make sure you check the "match entire cell contents" under the options button.

And if you needed a macro, you could record one when you did it manually.

> I don't know very much about coding macros at all so I was wonder how I
> would get one to change the content of a selected column's individual cells
[quoted text clipped - 3 lines]
>
> -- Bryan

Signature

Dave Peterson

Reply to this Message

Rate this thread: