ExcelBanter - Suppressing output

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Suppressing output (https://www.excelbanter.com/excel-programming/309353-re-suppressing-output.html)

Iain King

Suppressing output

"Ben H" wrote in message
...
Hi all! I am calling different files in a macro. The macro opens the
files,
reads in some data and then closes them. The problem I have is that the
files that are opened pop up and i was wonderig if there was a way to
suppress that.
Its really annoying to have the tables flash up and then dissapper.
Thanks!

Application.ScreenUpdating = False

Iain King

All times are GMT +1. The time now is 07:37 PM.