Results 1 to 6 of 6

Trying to get row numbers using Range object to Copy range to array

Threaded View

  1. #1
    Registered User
    Join Date
    12-06-2013
    Location
    Erie
    MS-Off Ver
    Excel 2003
    Posts
    3

    Trying to get row numbers using Range object to Copy range to array

    I am using the Range object to copy a range of rows from a worksheet into an array. I need to be able to edit various cells in the rows from the array and use the row number to copy the changed rows back to the worksheet. Is there any way to do this with my approach or must I revert back to reading row by row into the array so that I can query the row number by active cell? I can't find how to do my approach, but can't believe there isn't an easier approach than reading row by row to determine each row.
    Last edited by williamdor; 09-03-2014 at 12:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. using range.advancedfilter to copy data into a list object
    By mtnbiker98 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-28-2013, 02:58 PM
  2. [SOLVED] How to copy a range (including any formulas in the range) into an array?
    By jimmalk in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-28-2012, 01:51 AM
  3. [SOLVED] Name a dynamic range - Run-time error 1004 Method 'Range' of object'_Worksheet' failed
    By DavidBW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2012, 08:00 AM
  4. Pass Array to Range Object
    By Paluee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-21-2010, 01:44 PM
  5. [SOLVED] Range Question / error 1004: method Range of object Worksheet has failed
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2005, 10:06 AM

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