Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto-select within a macro
Never mind, I figured it out: (c:e).
Thanks a lot, Duke, that was very helpful! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Range Select | Excel Discussion (Misc queries) | |||
auto word select | Excel Discussion (Misc queries) | |||
Auto Word Select | Excel Discussion (Misc queries) | |||
Auto Word Select | Excel Discussion (Misc queries) | |||
auto word select | Excel Discussion (Misc queries) |