I am using the code below to change Chr(10) to HTML tags. It works fine in office 2010 and in 2003 when the amount of characters is low enough, however if the amount of characters in a cell exceeds 1024 then an error occurs. I assume this is because the replace function is limited to the max characters?

Is there a way around this? or if not is there a way to check the amount of characters before making the change or skip the cell and flag a variable to report the error?

Please Login or Register  to view this content.