VBA Auto Filter Error
I've written code to compare the data included in 2 huge Excel files and while running the comparison code I encounter a "Run time error '91' - Object Variable or With block variable not set". Anyone know what my error is? Please see picture below:
excel vba error.jpg
Thanks!
Isn't the AutoFilter.Sort command only available from XL2013 and upwards ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks