dyaron
Active Member
- Joined
- Nov 26, 2007
- Messages
- 291
I have a range of data and have the following statement
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlUp)).Select
Selection.Copy
This basically allows me to start at a cell, go left then up... but i want to go up to a specific row.. i.e. row one. So if there was 100 rows of data, I only want to select rows 2 through 100, omitting one. I tried this...
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlUp)-1).Select
Selection.Copy
But I get errors... again... I thank you all in advance
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlUp)).Select
Selection.Copy
This basically allows me to start at a cell, go left then up... but i want to go up to a specific row.. i.e. row one. So if there was 100 rows of data, I only want to select rows 2 through 100, omitting one. I tried this...
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlUp)-1).Select
Selection.Copy
But I get errors... again... I thank you all in advance