Flickering of sheets during save...Please help me..


Posted by Nikhita on December 01, 2000 11:49 AM

Hi,

I have an excel workbook which contains 8 sheets. THe
data in each row spreads through all the sheets.

Now while saving the data into a text file, I am reading
the data on row by row basis.

But while doing like this, workbook seems to be going
nuts, flickering a lot, as it jumps through all the sheets
to get a single data row.

Could you please help me, how can I fix this problem?

Your early help would be very much appreciated.

Thanks in Advance,
Nikhita

Posted by greg on December 01, 2000 2:16 PM

Response: Type this at the beginning of the macro: Application.screenupdating = false



Posted by Nikhitha on December 01, 2000 2:21 PM

Thanks a lot ...Greg