Working on a macro and looking to add a line in the beginning that if the activeworkbook does not have an xlsx extension then to exit the sub. Any ideas? Thanks.
Working on a macro and looking to add a line in the beginning that if the activeworkbook does not have an xlsx extension then to exit the sub. Any ideas? Thanks.
Try this...
If Right(ActiveWorkbook.Name, 4) <> "xlsx" Then Exit Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks