Good morning, This line of code works, but it obviously does not copy just the visible cells.
I went to modify it (like below) so that it would copy just the visible cells value (I'd like the code to be all one line) but the syntax is off. Any ideas?
Please Login or Register to view this content.
Please Login or Register to view this content.
thanks!
Last edited by davesexcel; 02-02-2021 at 09:32 AM.
I'm pretty sure that when you are assigning values from one range to another, both ranges need to be the same size.
Thanks!
I believe that the range is the same size. I just need to pull the "visible" portion of the range.
The syntax error goes away if I remove the ".value", but then it still does not paste the visible cells only.
To be clear, I did cross post this issue to one other form:
https://www.mrexcel.com/board/thread...f-vba.1160398/
If they solve it there I'll be certain to mark it as solved here and advise what the resolution was.
Thank you for your help, this has been resolved with this code:
PS.Range(PS.Cells(1, ColItemID), PS.Cells(lastrow, ColItemID)).SpecialCells(xlCellTypeVisible).Copy PSU.Range("a1")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks