How to copy/paste only what is visible

[nenadmail]

I have this code below and it copies everything in Range("AA7:AQ100")
But I want it to only copy/paste the VISIBLE ROWS, not all of them.
So when the result is pasted in "AA105" it will paste only what is visible

How do I correct this code????
Please help!

Please Login or Register  to view this content.

Thanks!

[benishiryo]

hi nenadmail. just a wild guess by playing around with recording, you can try using this:

Please Login or Register  to view this content.

instead of just:

Please Login or Register  to view this content.

not an expert in VBA though. sorry if it didnt help

[nenadmail]

Please Login or Register  to view this content.

Excellent... it works when there's something to select... but in case there's nothing visible in the range to select... I need the macro to STOP and END with just the following:

Please Login or Register  to view this content.

[royUK]

Copying a range with hidden rows & columns will only copy what is visible anyway

[nenadmail]

Right... but sometimes there's nothing visible in that range.... so I need the code to behave differently in that case.

I just need to insert somewhere:
If nothing selected, ELSE go to Range "A1"

[royUK]

If you are going to use SpecialCells then it's best to wrap an error handler round to prevent an error caused by the lack of any Specialcells

Please Login or Register  to view this content.

[nenadmail]

Thanks... but your code changed a lot of things... the previous one worked, all I need is one little change which is:

PUT "ELSE" in it to just behave a little differently.
IF ALL ROWS end up being hidden, then END Macro with: Range("A1").Select


This section of the code below can sometimes in certain circumstances HIDE everything in the range of rows "7:100"...

Please Login or Register  to view this content.

IF that happens, then all I need is something to be added in the code to STOP the VBA from running the rest of the code, which is the following section:

Please Login or Register  to view this content.

ELSE, in this rare but plausible case the VBA needs to end with only:

Please Login or Register  to view this content.

Please, if you can do that only... It will be fine and work perfectly!
Thank you very much for your help... I really appreciate it!