+ Reply to Thread
Results 1 to 2 of 2

Selecting Rows with Macro

  1. #1
    jhahes
    Guest

    Selecting Rows with Macro

    Could someone please help with the following

    I have a macro that will select some cell say L200

    Is there anyway that I can have the macro select all of the row that the active cell is currently in and also select all the rows to row 600.

    So all that is selected is the activecell row and the rest to 600

    so if the active cell is in 500 - 500 to 600 would be selected (the whole row)

    Thanks for any help!

  2. #2
    Forum Contributor
    Join Date
    11-09-2004
    Posts
    451
    sub macro()

    rows(activecell.row & ":600").select

    end sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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