+ Reply to Thread
Results 1 to 6 of 6

macro remove rows

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    macro remove rows

    Hello everyone,
    in the attached file is inserted a macro to delete rows.
    You can a change?
    Now if I select a row in the userform it shows the line number.
    If I select more than one row in the userform is only the number of a row might still be all the line numbers selected?
    I hope I explained.
    max_max
    ---------------------------------------------------------------------------------------------------------------------
    Salve a tutti,
    nel file allegato è inserita una macro per eliminare righe.
    è possibile una modifica?
    Ora se seleziono una riga nella userform viene indicato il numero di riga.
    Se seleziono più di 1 riga nella userform viene indicato solo il numero di una riga è possibile che venga indicato tutti i numeri di riga selezionati?
    Spero di essermi spiegato.
    max_max

    elimina riga_max.xls

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: macro remove rows

    Hi max_max,
    try this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro remove rows

    Thanks nilem,
    It is almost perfect.
    it is possible that the selected row is indicated all?
    I mean:
    if selected lines are 1-2-3-4-5 and identified 1-2-3-4-5 and not 1-5
    max_max
    ----------------------------------------------------------------------
    Grazie nilem,
    è quasi perfetto.
    è possibile che le righe selezionate sia indicate tutte?
    Mi spiego:
    se le righe selezionate sono 1-2-3-4-5 devono essere indicate 1-2-3-4-5 e non 1-5
    max_max

    elimina riga_max_2.xls

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: macro remove rows

    maybe so
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro remove rows

    Привет nilem.
    Благодаря нормально.!
    приветствие.
    max_max

    Если Google переводчик перевод точно
    if google translator translated exactly
    ---------------------------------------------------
    Hello nilem.
    Thanks is ok.!
    A greeting.
    max_max
    --------------------
    Ciao nilem.
    Grazie è ok.!
    un saluto.
    max_max

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: macro remove rows

    You are welcome!
    На здоровье

+ 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. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 PM
  2. How to remove unique rows (macro)?
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2011, 01:45 PM
  3. macro to remove rows with zeros in them
    By antonyjones101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2009, 03:53 PM
  4. Macro to remove rows
    By horseyshoe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2006, 12:13 PM
  5. [SOLVED] Need macro to remove blank rows
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2006, 08:25 AM

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