Results 1 to 20 of 20

Macro Error When Deleting Columns and Rows

Threaded View

Allienne Macro Error When Deleting... 09-18-2018, 09:20 AM
Norie Re: Macro Error When Deleting... 09-18-2018, 09:40 AM
Allienne Re: Macro Error When Deleting... 09-18-2018, 09:43 AM
Norie Re: Macro Error When Deleting... 09-18-2018, 09:56 AM
Allienne Re: Macro Error When Deleting... 09-18-2018, 10:03 AM
xladept Re: Macro Error When Deleting... 09-18-2018, 11:47 AM
Allienne Re: Macro Error When Deleting... 09-18-2018, 11:56 AM
xladept Re: Macro Error When Deleting... 09-18-2018, 12:08 PM
Allienne Re: Macro Error When Deleting... 09-18-2018, 12:10 PM
xladept Re: Macro Error When Deleting... 09-18-2018, 02:29 PM
xladept Re: Macro Error When Deleting... 09-18-2018, 12:47 PM
Norie Re: Macro Error When Deleting... 09-18-2018, 01:19 PM
Allienne Re: Macro Error When Deleting... 09-18-2018, 01:41 PM
xladept Re: Macro Error When Deleting... 09-18-2018, 03:08 PM
Allienne Re: Macro Error When Deleting... 09-18-2018, 02:31 PM
Allienne Re: Macro Error When Deleting... 09-18-2018, 03:10 PM
xladept Re: Macro Error When Deleting... 09-18-2018, 04:03 PM
Allienne Re: Macro Error When Deleting... 09-18-2018, 04:04 PM
xladept Re: Macro Error When Deleting... 09-18-2018, 04:53 PM
xladept Re: Macro Error When Deleting... 09-19-2018, 11:23 AM
  1. #1
    Registered User
    Join Date
    05-10-2018
    Location
    Pennsylvania
    MS-Off Ver
    Office 365
    Posts
    43

    Macro Error When Deleting Columns and Rows

    Hello!

    So this is a new thing that has cropped up. I have a macro that is supposed to delete columns and rows but it throws the Error "Delete method of Range class failed". I investigated and the macro is the same that I had used with the previous version of Excel, but the document will not allow me to delete columns or rows at all, even manually. I have it unprotected and I can select the columns or rows and right click to delete and it clears the cells of all text but leaves the columns there only blank instead of deleted.
    Example Not Deleting.jpg

    We did just update from Office 2013 to Office 365 and the macro worked before we updated.

    Any help would be appreciated.
    Last edited by Allienne; 09-18-2018 at 04:05 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. getting a ref error when deleting columns
    By greycamaro in forum Excel General
    Replies: 4
    Last Post: 05-05-2017, 01:29 AM
  2. [SOLVED] Error Checking Macro to cycle through rows looking at specific columns for things
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2015, 08:36 PM
  3. [SOLVED] 2010 Macro Issue - deleting columns and rows
    By Scalpel4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2015, 07:49 PM
  4. Code/Macro for deleting empty columns and rows.
    By gautamacharya in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 01:49 PM
  5. [SOLVED] Error 13 - Type Mismatch for my macro code for deleting rows based on condition.
    By Whitenoise1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-19-2012, 07:56 PM
  6. VBA 1004 Error Deleting Rows or Columns
    By CaptMac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-23-2010, 03:46 PM
  7. [SOLVED] Error when deleting rows
    By wmureports in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 03:25 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