I am not a programmer. I typically create macros and do minor VBA editing to
make things work.
I've created a macro that searches a column for specific occurrences (",")
and replaces them with a comma and a space. The problem is that one cell
sometimes contains too many characters. When that occurs, I get a Formula
too long error and the macro stops running.
Can you advise on how to correct the code? (see below)
*******
Cells.Replace What:=",""MEETINGS LIST""", Replacement:="", LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

Signature
Gail Hines
Texas State Auditor''s Office
ghines@sao.state.tx.us
512-936-9760
Don Guillett - 13 Jan 2007 01:14 GMT
Perhaps you should restrict to the column desired. try
columns(3).Replace What:=",MEETINGS LIST", Replacement:="", LookAt:=xlPart _
, SearchOrder:=xlByRows

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>I am not a programmer. I typically create macros and do minor VBA editing
>to
[quoted text clipped - 11 lines]
> , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
> ReplaceFormat:=False