Office 2000 vs 2003
 

I have some code that I created using Excel 2003 but when user's who have
2000 try to run it they get some errors. Here is a sample of the code they's
choking:

Columns("A:F").Select
Selection.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

I was thinking it had something to do with the x1 part of the code but I'm
not sure. I'm not a programmer I just wrote this by recoding my tasks in a
macro and tying eveyrthing together. If there is an issue with code between
office versions is there a more standard format for me to use?

Office 2000 vs 2003
 

Columns("A:F").Select
Selection.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

Should be sufficient. The ability to replace formats was addin in xl2003 as
I recall, so it isn't understood by xl2000 (the replace function didn't
have those arguments). Not using those arguments in xl2003 will not cause a
problem since you are not replacing by format.

--
Regards,
Tom Ogilvy

"hshayh0rn" wrote in message
...
I have some code that I created using Excel 2003 but when user's who have
2000 try to run it they get some errors. Here is a sample of the code
they's
choking:

Columns("A:F").Select
Selection.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

I was thinking it had something to do with the x1 part of the code but I'm
not sure. I'm not a programmer I just wrote this by recoding my tasks in a
macro and tying eveyrthing together. If there is an issue with code
between
office versions is there a more standard format for me to use?

Office 2000 vs 2003
 

In Excel 2000 the .Replace method does not have an option for SearchFormat or
ReplaceFormat. Try taking those out of the code:
Columns("A:F").Select
Selection.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

If you will be working with both Excel versions, record your macros on the
earlier one - most of the earlier code will work in later versions, while any
new features in 2003 will bomb on 2000. Either that or you will have to
learn how to dig into VBA code and objects!
--
- K Dales


"hshayh0rn" wrote:

I have some code that I created using Excel 2003 but when user's who have
2000 try to run it they get some errors. Here is a sample of the code they's
choking:

Columns("A:F").Select
Selection.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

I was thinking it had something to do with the x1 part of the code but I'm
not sure. I'm not a programmer I just wrote this by recoding my tasks in a
macro and tying eveyrthing together. If there is an issue with code between
office versions is there a more standard format for me to use?