Hi, i am trying to write a macro that deletes the content of two tables on seperate worksheets. The headers should be kept. Somehow i am getting a messagebox of excel asking me wheter i want to deltethe whole row. I would like the macro to perform the task without the message box. How can i change my code to perform the task?
Any input is much appreciated!
Please Login or Register to view this content.
Try this way.
Please Login or Register to view this content.
Last edited by bakerman2; 07-09-2020 at 03:24 AM.
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