peterb1985
MIS
Sub test1()
Worksheets("sheet1"
.Columns("AD"
.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.
Worksheets("sheet1"
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.