How to auto-select within a macro
 

Hello,

I recorded the following simple macro to check for a problem in some columns
on a worksheet I'm working on daily.

Selection.Replace What:=".988", Replacement:=".99", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

However, there are some additional common problems I would like to take care
of, and I thought of chaining several similar macros (essentially just
changing the values for "what" and "replacement") so that in the end, I'll be
able to click one button to check for all of them.

What I am wondering is how to specify particular columns, and also the
entire sheet, in a macro. Some of the potential problems I'm trying to catch
can occur anywhere on the sheet, whereas others are only an issue in certain
columns. Applying that fix to other columns could have undesirable results.

Thank you.

How to auto-select within a macro
 

Let's say you want the macro to work on column C

Replace

Selection.

with

columns("C").

To act on the entire worksheet use

cells().


"Niniel" wrote:

Hello,

I recorded the following simple macro to check for a problem in some columns
on a worksheet I'm working on daily.

Selection.Replace What:=".988", Replacement:=".99", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

However, there are some additional common problems I would like to take care
of, and I thought of chaining several similar macros (essentially just
changing the values for "what" and "replacement") so that in the end, I'll be
able to click one button to check for all of them.

What I am wondering is how to specify particular columns, and also the
entire sheet, in a macro. Some of the potential problems I'm trying to catch
can occur anywhere on the sheet, whereas others are only an issue in certain
columns. Applying that fix to other columns could have undesirable results.

Thank you.

How to auto-select within a macro
 

It's that simple? Sweet.
How do I specify several columns?

Columns("c","d","e")? Or columns ("c"), ("d"), ("e")? Or something
completely different?

How to auto-select within a macro
 

Use:

columns("C:E")

"Niniel" wrote:

It's that simple? Sweet.
How do I specify several columns?

Columns("c","d","e")? Or columns ("c"), ("d"), ("e")? Or something
completely different?

How to auto-select within a macro
 

Never mind, I figured it out: (c:e).

Thanks a lot, Duke, that was very helpful!

How to auto-select within a macro
 

Just out of curiosity - do you really need the ""? It seems to be working
without, but maybe there's a good reason to add those?