excel macro inconsistency

[JM]

I recorded a macro which selects a column and then
replaces all instances of "-" with "". I cut and pasted
the recorded code into a larger macro. If I run the macro
it does not execute the replacement, but does not generate
any errors. If I step through the macro via the debugger
the replace executes properly. Anyone know what is going
on? Some kind of timing issue?

 

[KL]

Pls. post the code.

KL

 

[Frank Kabel]

Hi
see your other post

 

[JM]

Columns("B:B").Select
Selection.Replace What:="-", Replacement:="",
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

This code is in a procedure, and is called within the same
module. If I step through the code it works fine.

JM

 

[Guest]

Code posted in reply to KL

-----Original Message-----
Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Frank Kabel]

Hi
try:
Activesheet.columns("B:B").Replace What:="-", Replacement:="",
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

 

[JM]

I figured it out, actually. I was running a query and then
formatting the data, but the query was not finished before
the formatting started. I set the backgroundquery
condition on the refresh command to false, and now ti the
timing is fine. Thanks though!