Copying Visible Cells Only

[Chi Sin Wolf]

Greetings,

I have done a lot of searching, and it seems that you can't copy visible cells only that have been generated by the sub-totals feature.
So, does anyone know of a macro that can filter out and delete rows that do not contain bold text.

Or if any kind soul could offer another solution, I would be very grateful.

Thank You.

[noranthon]

The indefatigable Villeroy has provided a solution: http://www.oooforum.org/forum/viewtopic.phtml?t=38775&highlight=copy+visible
_________________
search forum by month

[Chi Sin Wolf]

[Chi Sin Wolf]

Thank You Noranthon and Villeroy.

I deleted the space after the hyphen and now it works perfectly.
This is exactly what I was looking for.

I can't thank you guys enough.

Rgds. Happy Chi Sin.

[noranthon]

I have added a post about your amendment to the other thread. I noticed that V's sig contains a link to the following: http://www.ooomacros.org/user.php#188206
_________________
search forum by month

[Chi Sin Wolf]

Actually, there were two areas where I had to delete a space after pasting. Sorry I didn't mention this before.





I imagine experienced people already know that if an underscore is at the end a line, it should be the final character i.e. no space. But I thought I'd flag this in case the not so experienced like me have a similar problem.
It's just that some times when copying and pasting, spaces can appear.
This fact is clearly mentioned in this forum in the "How to install a macro found here" section. http://www.oooforum.org/forum/viewtopic.phtml?t=7995

Thanks again for the help. This is an extremely helpful forum.