Hello friends,
I have a functional macro that adds empty rows every 6 rows. Here it is:
Now, I can't seem to figure out where in this code I enter the shade I would like these new rows to be, preferably .TintAndShade = -0.249977111117893. And not to color the entire row, but only cells between columns A to H.
Please Login or Register to view this content.
Can someone help me figure that out?
THANK YOU SO MUCH. I can't wrap my brain around this one!
Last edited by MiGGsHz; 03-17-2016 at 03:30 PM.
Perhaps:
Untested of necessity.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Perhaps:
Untested of necessity.
Please Login or Register to view this content.
Visually, what color is that?
Edit: Nevermind, Mehmetcik's solution works for me
Last edited by CAntosh; 03-17-2016 at 04:20 PM.
This worked perfectly.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks