Results 1 to 2 of 2

Select a range from active cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    17

    Select a range from active cell

    Hi
    I am trying to select a specific range (4 rows down, 10 columns right from active cell) in order to cut and paste the selection to another cell within the worksheet.The range might be anywhere within the worksheet so am unable to specify exact range.
    I found the following code and would appreciate any help in modifying it to meet my requirements.
    Range(ActiveCell, Range(ActiveCell.Address).End _
    (xlToRight).End(xlDown)).Select
    Thanks in advance
    Spagbog

    Thanks Dom

    Excellent result just what was required.
    Last edited by Spagbog; 12-21-2011 at 10:01 AM.

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