excel vba - Run time error on Do Loop in VBA -


i wrote vba script perform bulk find , replace in excel. need perform function on 150,000 cells worth of data. use loop compare value on sheet values (find) , related codes (replace) on sheet b.

i using index counter declared dim integer, loop controlling each iteration of index. vba script works, receive "run-time error '6': overflow" error message once index crosses 30,000? there limit how many times can iterate loop, or know of way perform bulk find , replace in excel?

try this

activesheet.cells.replace(oldvalue,newvalue,xlpart)

activesheet.cells contains cells within sheet.

hope helps


Comments

Popular posts from this blog

c# - HttpResponseMessage System.InvalidOperationException -

sql - Postgresql error: "failed to find conversion function from unknown to text" -