Excel macro gives error msg "formula is too long."

[peterb1985]

Sub test1()
Worksheets("sheet1&quot.Columns("AD&quot.Replace _
What:=Chr(13) + Chr(10), Replacement:=" "
End Sub

This is my very simple macro designed to remove carrige return things from cells. By spreadsheet contains 16800 records with a full description which has carrige returns in it. The macro works on 10200 records then i get an error msg firmula is too long. I've read that this might be because the string in the cell contains more than 305 characters.

Does anyone know how to get around this anoying problem? As i want to add the file to my mysql database soon.

 

[Chattin]

Check out the xl help on 'specifications' - you'll see

"Length of formula contents 1,024 characters"

May be the problem?

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[peterb1985]

So how do i get my macro to work if the cell contains more than 1024 characters which it does by the way.

Thanks anyway.

 

[Chattin]

Quote "peterb1985
So how do i get my macro to work if the cell contains more than 1024 characters which it does by the way."

AFAIK you can't - one of the limitations of xl unfortunately


Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help