Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Problem with Find function in VBA

Hello,

I use the Excel Find function to search values in one sheet. The problem is
that when i use this function many times, the sheet is corrupted. I means
that when I save my workbook, its size increases dramatically (from 100Ko to
2Mo and more).
Moreoever, when I select the sheet, I have to wait more than 1s to change
the selected cell!

It seems that the objects generated by the search are not deleted.

can comeone help me to solve this problem??


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match Function Problem - Won't Find Certain Numbers PE Excel Discussion (Misc queries) 2 May 9th 05 03:53 PM
range.find method called into a VBA function (problem) Eros Pedrini Excel Programming 5 November 17th 04 12:34 PM
Excel VBA Problem- Using Find Function anandmr[_2_] Excel Programming 5 July 20th 04 10:12 PM
Problem in VBA with function FIND(... Decaplan Excel Programming 1 May 21st 04 03:00 AM
Problem with Find function Snedker Excel Programming 1 December 17th 03 10:37 PM


All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"