Hi,
Fairly new to Excel, but managed to create (with some help) a macro that hides all rows without any colour filled cells in it. I tried to transfer the macro to a new worksheet and it wont work any more.
Can you please help me understand and fix what's wrong?
Here is the macro, also I've attached the doc.
PA Servicing schedule 12-13 kellys USE THIS.xlsm
Please Login or Register to view this content.
Last edited by kellynicolebarrett; 04-30-2014 at 08:09 AM.
first you need to put your code between code tags because it creates problems for mods who are working day in and day out to keep the things clean at the same time it's difficult to understand. See forum rule for how to add code tags
You can add code tags by clicking # then inserting code in between code tags
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
1) please edit your post and use code tags as required by http://www.excelforum.com/forum-rule...rum-rules.html
2) in your worksheet there is a lot of cells which have not empty fill -4142 but white color (index = 2)
could be the curePlease Login or Register to view this content.
3) moreover LC is calculated wrong way - have a closer look into your sheet (for instance columns GG and others to see why).
4) see p.1 and do edit your post.
Best Regards,
Kaper
As you are copying code to a new worksheet and it is not working I think you need to change sheet name just change the red part to the name of the sheet
Please Login or Register to view this content.
do edit your post
Last edited by hemesh; 04-30-2014 at 05:50 AM.
As you are copying code to a new worksheet and it is not working I think you need to change sheet name just change the red part to the name of the sheet
do edit your postPlease Login or Register to view this content.
ok, thanks for the tip I've used the tags on my code (see above post)
I did actually change my sheet to the same name as the old one, I thought that would solve it but it didn't.
you need to change the sheet name to the sheet where you want to use it or use
Please Login or Register to view this content.
kaper you are right with the below
3) moreover LC is calculated wrong way - have a closer look into your sheet (for instance columns GG and others to see why).
With that in mind, is it possible to set it so that it shows only rows with green or red filled cells?
Try:
Please Login or Register to view this content.
I know what the problem is, but have no idea how to solve it. As an example if I click on my "february" button it hides all my columns except feb's. When the macro looks for rows with no fill colour to hide, it is still picking up the colour in the hidden rows. In this example, I basically want to see only the servicings (coloured cells) due for february. And the same for any month that I filter.
Is there a way around it to have an altered macro on each month that only searches through the relevant columns (so for Feb H-K). So it would hide all rows with no fill colour in H-K?
Try to limit your myRange to only visible columns:
Please Login or Register to view this content.
kaper you legend! That works perfectly. Thanks so much. And thanks to hemesh for your replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks