+ Reply to Thread
Results 1 to 2 of 2

Restore deleted rows and cells, or repair error pop up message

  1. #1
    Registered User
    Join Date
    08-14-2020
    Location
    Croatia, Slavonski brod
    MS-Off Ver
    Microsoft office 365 ProPlus
    Posts
    9

    Restore deleted rows and cells, or repair error pop up message

    Hi all!

    In my excel workbook, i have deleted unused rows below my last used row, as well as columns right from my last used columns.

    But now, when i filter some specific columns, i get error message "fixed objects will move".

    Is it possible to restore all unused rows and columns which i deleted, or fix this pop up message?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,858

    Re: Restore deleted rows and cells, or repair error pop up message

    .
    Application.DisplayAlerts = False


    Use the above at the beginning of your macro .... then, use the following at the end of your macro :


    Application.DisplayAlerts = True



    You can Google: VBA Application.DisplayAlerts for more information.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Error next without for and how to restore all tables to only three rows.
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-26-2018, 12:30 PM
  2. How to restore deleted CSV files?
    By Iyatto in forum Excel General
    Replies: 2
    Last Post: 10-15-2012, 12:30 PM
  3. Need message box stating number of rows deleted by macro
    By Research RN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2009, 06:26 PM
  4. Restore deleted Mail Folder?
    By J.wills in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2009, 03:21 AM
  5. Replies: 2
    Last Post: 10-06-2005, 08:05 PM
  6. Restore a deleted Excel Workbook?
    By Ashby in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2005, 11:05 PM
  7. [SOLVED] Restore a deleted document
    By Restoring a document in forum Excel General
    Replies: 2
    Last Post: 01-21-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1