delete txt vba --> stack overlflow

[vermaccio]

i have maaany rows (about 38000 rows but soon thay will become more and more)

in column "A" there is text "xxx"

(warning: xxx is together followed spaces, really is something as "xxx " and i don't know how many spaces there will be. for me is important to delete xxx and not also spaces, i will delete them later by other vba)

i wrote a VBA to replace "xxx" with "".

the VBA give error "stack overflow" due to, i think, the huge number of rows. infact if i delete many rows the vba works.

any solution?


more: in column "A", see filter, there is a special chatacter (the card spades sign). but if i try to copy it to paste in the vba code to delete also it... i can't copy it. any idea?

see attached file

[jindon]

Please Login or Register  to view this content.

[AB33]

Not sure what exactly you are after, but integer could only take 32k rows, so change to

Dim rows_unicode_100 As Long

[KOKOSEK]

It should works:

Please Login or Register  to view this content.

[vermaccio]

thank you. solved.