+ Reply to Thread
Results 1 to 10 of 10

cutting rows in each worksheet

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    332

    cutting rows in each worksheet

    hey guys
    i wanna edit this attached file for premier league statistics
    now its designed for 24 clubs in that league
    but premier league has 20 club in the competion
    so how i can write a code for deleting in all worksheets inside the file except "fixture" and "results" worksheets

    i mean
    i wanna delete automatically no. 23-24-25-26 rows in the following sheets: "GOALS 2.5" , "goals3.5" , "BANDS" , "firsthalf" , "team 2.5"

    pls help me.
    Attached Files Attached Files
    Last edited by aaaaa34; 02-27-2014 at 10:42 AM.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: cutting rows in each worksheet

    If you delete rows 23-26, you still left with 21 clubs, not 20,Exlcuding Galataseray
    Attached Files Attached Files

  3. #3
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    332

    Re: cutting rows in each worksheet

    ahahha my friend u re great!!!
    u chelsea fan?

    in fact i wanted to delete row 23 as well my friend. i said rows 23-24-25-26 together.

    so this part of code should be like this:

    Case Else
    .Rows(22 ?? ).Resize(4 ??).Delete

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: cutting rows in each worksheet

    Yes, you know how to modify it.
    I am a Gunner

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: cutting rows in each worksheet

    Or

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    332

    Re: cutting rows in each worksheet

    oooo arsenal fan
    then please pray for us in stanford bridge
    bcuz drogba and schnejider didnt play anything last night
    if they can play good in next match, we ll beat them there!!!
    and i ll pray for arsenal for match in munich

  7. #7
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    332

    Re: cutting rows in each worksheet

    only my friend,
    why it gave this error ?

    http://postimg.org/image/skpxf1zv3/

  8. #8
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: cutting rows in each worksheet

    You left out the"" mark, Look at my post # 5.
    It is over for Gunners. You might have a chance!

  9. #9
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    332

    Re: cutting rows in each worksheet

    ah yes
    tamam süper!!!
    thanks a lot buddy

  10. #10
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    332

    Re: cutting rows in each worksheet

    ehehhe last year u was close to do miracle
    so for this year why not too
    just mesut should go out less at nights : )))

    thanks a lot for ur response AB33!!!
    take care urself
    see ya

+ 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] Please explain this macro for cutting rows
    By freshfruit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2014, 02:34 PM
  2. VBA Cutting and Pasting from one worksheet to another based on value
    By aeewing in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2013, 10:27 AM
  3. Cutting the same data from different rows and pasting them into the same rows
    By Sal1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 05:22 PM
  4. [SOLVED] Cutting Nonadjacent Rows
    By RJ in forum Excel General
    Replies: 2
    Last Post: 08-08-2005, 04:05 PM
  5. [SOLVED] Worksheet lines cutting off on the right
    By HT in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-07-2005, 01: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