Thread: how to speed Find/Replace in Excel(Using VB)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
replace one tag in content of one cell a[_2_] replace one tag in content of one cell a[_2_] is offline
external usenet poster
  
Posts: 3
Default how to speed Find/Replace in Excel(Using VB)
In my project,one excel file is used as template.there are many tags in the
file and these tags will be replaced.
I use VB to reach to the aim through Excel Activex,but I notice it is very
slow.
it took more than ten seconds to replace all tags.
how can I do it? thanks.


Reply With QuoteReply With Quote