Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Smile Unanswered: macro to select row

    I have a worksheet that contains vehicle details. Column A contains vehicle serial numbers in ascending order. I want to select the serial number from a list then run a macro which selects the entire row ready for cutting or copying but I have no idea how to do it. Is there a simple way?

    Cheers

  2. #2
    Join Date
    Jul 2007
    Posts
    54
    Why use a macro? Why not just use the LOOKUP function? You would have to sort the vehicale data sheet by the serial numbers. Also be careful if any of the serial numbers have leading zeroes as Excel may choose to see some as numbers and then that could mess up the sorting.

    HTH
    Caspar

Posting Permissions

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