LinkBack URL
About LinkBacks
how do you apply formatting to just visible cells?
how do you apply formatting to just visible cells?
If some cells are not visible, why would it matter if they got formatted as well?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
LOL. Thank you Ford, made my night.If some cells are not visible, why would it matter if they got formatted as well?
TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Happy to help, Trev
But if you really want to do that:
Select cells that you what to format and press F5, click Special and select Visible cells only and click OK. Apply format.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks