What code do I need to insert to ensure the macro runs on startup?
The code works great on books I have already opened and saved.
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). Find(What:="*", Look At:=xl Part, Match Case:=False, Search Order:=xl By Rows, Search Direction:=xl Previous) Set callno = . Find(What:="Call No", Look At:=xl Part, Match Case:=False, Search Order:=xl By Columns, Search Direction:=xl Next) pastecell. Remove Duplicates Columns:=5, Header:=xl Yes Application. Name At the beginning of the code, I disable Display ALerts, Screen Updating, Enable Events and Ask To Update Links, we need to make sure no message box is prompted to interrupt the refresh code.I have 77 excel workbooks that are created each week, they are all in the same directory. JMAN What I have to do is open every one of the files in this directory, Select one of 3 tabs, copy that data into a new workbook.