Results 1 to 4 of 4

Range Select problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-09-2006
    Posts
    147

    Range Select problem

    I am having a problem putting a range select statement in my macro. Here is what I'm trying to do.

    I want to select E1, then count down 10 cells below and copy. My sheet is filtered, so those rows are not continues. When I do the record a macro it highlights the rows and it looks like this (e10:e506, but it's only 10 items). I only want it to count down 10 cells and copy.

    Is there a statement for this.
    Last edited by rlkerr; 01-28-2009 at 06:07 PM.

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