+ Reply to Thread
Results 1 to 5 of 5

Excel VBA - Rows Getting Deleted on running macros.

  1. #1
    Registered User
    Join Date
    06-27-2020
    Location
    India
    MS-Off Ver
    365
    Posts
    19

    Excel VBA - Rows Getting Deleted on running macros.

    Hi All,
    I have earlier created a job tracking sheet which was fine but was very big horizontally.
    Was having difficulties while taking printouts etc. Hence I have been advised to changed.
    To accommodate the report in an A4 paper, I have prepare the job in multiple lines (two
    lines.). Created two macros - when Column K is having 100%, then the first line of the job
    will be moved to next sheet on button click and when Column K is having "OK", the second
    line will be moved to the next sheet relevant columns on button click.

    The macros are running fine. However, after execution of the macros, the rows from top
    are getting deleted. I request your help to get the same corrected.

    Attached herewith the file.

    Kindly help.
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,599

    Re: Excel VBA - Rows Getting Deleted on running macros.

    Possibly...
    Please Login or Register  to view this content.
    ____________________________________________________________
    If I've been helpful, let me know. If I haven't, let me know that too.

  3. #3
    Registered User
    Join Date
    06-27-2020
    Location
    India
    MS-Off Ver
    365
    Posts
    19

    Re: Excel VBA - Rows Getting Deleted on running macros.

    Thanks a lot dangelor.. its working fine now.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,599

    Re: Excel VBA - Rows Getting Deleted on running macros.

    Glad I could help!

  5. #5
    Registered User
    Join Date
    06-27-2020
    Location
    India
    MS-Off Ver
    365
    Posts
    19

    Re: Excel VBA - Rows Getting Deleted on running macros.

    Hi Dangelor... Even though the initial problem of rows getting deleted has been
    solved, I am facing another issue.

    The Filtration criterial "OK" is considering only the first rows (Row No.5 and 6).
    Consider job of rows 5 & 6 is pending, but job of rows 7 & 8 is finished, the
    macro is not working.

    Please guide suitably.

+ 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] Excel 365 - Macros Not working within the Ribbon (Moved,Renamed,Deleted)
    By dave_w1967 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2019, 12:57 PM
  2. [SOLVED] Hiding the file when running macros and after running macros
    By thilag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2016, 07:15 AM
  3. [SOLVED] Excel running slow even with all content deleted
    By adlerj in forum Excel General
    Replies: 8
    Last Post: 04-11-2014, 09:42 AM
  4. EXCEL: Protect Rows Being Deleted.
    By gaikwad.mm@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2013, 01:58 AM
  5. Replies: 5
    Last Post: 02-17-2010, 02:02 PM
  6. [SOLVED] Accidently deleted rows in Excel.
    By Pelochino in forum Excel General
    Replies: 2
    Last Post: 10-13-2005, 05:05 PM
  7. [SOLVED] I deleted all macros in Excel but still get dialog box
    By VenitaC in forum Excel General
    Replies: 2
    Last Post: 09-19-2005, 03:05 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