I cant seem to figure out why its not coloring every other row to the entire data but stops half way through. Can someone please take a look at this. Thanks
Please Login or Register to view this content.
I cant seem to figure out why its not coloring every other row to the entire data but stops half way through. Can someone please take a look at this. Thanks
Please Login or Register to view this content.
It may not looping through the entire rows.
Try
and change this linePlease Login or Register to view this content.
INTOPlease Login or Register to view this content.
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
Martin
If your data starts at A19 and goes to A50, and you reference the UsedRange.Rows.Count will be 31, but your range will only extend from A19:A31.
Instead, I'd go with:
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thanks...worked great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks