Results 1 to 7 of 7

Selecting certain rows

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Selecting certain rows

    Hi All,

    I am currently in the process of streamlining some VBA code which I obtained via record macro and was wondering if I someone would be able to point me in the right direction.

    I want to select cells from B6:B150 then copy and paste to another location. This process is repeated for over 20 columns (e.g. D6:E150, F6:F150 etc).
    As the there are gaps inbetween rows 6 -150 (for formatting), I have this clumsy code which repeats the below multiple times until it gets to row 150:
     Range(Selection, Selection.End(xlDown)).Select
    Is there a easier way of selecting these rows?
    Thanks for your help.
    Last edited by daviddcosta1; 09-02-2013 at 09:57 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error When Selecting Sheet then Selecting Range
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2012, 04:11 AM
  2. [SOLVED] Selecting last row
    By mhayli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2006, 05:30 AM
  3. Selecting
    By Viktor Ygdorff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2006, 08:30 AM
  4. Selecting last row?
    By edward0380 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2006, 03:45 PM
  5. Selecting every 3rd row ???
    By Larry in forum Excel General
    Replies: 1
    Last Post: 03-17-2005, 09:06 PM

Tags for this Thread

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