Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Hlp! Adv Filter - Non-Contiguous rows don't copy
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Joyce, post: 6439633"] Hello again, I'm also trying to remove a step from the user that would force them to select the first 4 columns of rows displayed as a result of the advanced filter. I'm trying (unsuccessfully) to begin the macro with selecting the dynamic range name called FilteredData (that includes only the first 4 columns) visible cells only. I keep getting errors. I'm trying: Range("FilteredData").Select Selection.SpecialCells(xlCellTypeVisible).Cells.Select Thanks. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Hlp! Adv Filter - Non-Contiguous rows don't copy
Top
