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.
Bookmarks