I bring data into a spreadsheet, then filter to get the information I need. The information can be one row or thousands of rows of data. Is there a way to select one, if only one item is found, or all items, if more than one are in column I. The formula I use works well (see below) except with only one item under the heading it selects the whole column. I don't want the whole column.
Range("I2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Please Login or Register to view this content.
Ben Van Johnson
Hi,
It's rarely necessary to use .Select .Activate and similar, it just slows down the code. Just address the relevant range directly.
In your case
Range("I2", Range("I" & Rows.Count).End(xlUp)).Copy
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you Richard. That worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks