Application screenupdating in vba

Rated 3.95/5 based on 901 customer reviews

With small macros speed is irrelevant - they execute in a split second.

However when your programs start to grow bigger and bigger, efficient code and speed becomes an isssue.

' We use Long in case they have over 32,767 rows selected. Screen Updating = False ' We work backwards because we are deleting rows.

procedure I want to write a quick if-statement which checks whether the user has made a valid input (user chooses number of project from list of data, see attached screenshot).

For that I am checking whether the project number is not part of the list of projects.

It is important to note that the least efficient methods involve those that use loops.

This is because they only delete one row at a time!

Leave a Reply