View Single Post
 
Old 06-17-2014, 10:44 AM
EC37 EC37 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

Where you asked that I perform the End Down function while in K1, and asked what row I was in- it shot me to the last possible row (1,048,576). Not sure if that was what it was supposed to do or not! But my answer is 1,048,576!

My only question for this part of the lesson is this: If we are coloring the rows simply on the content of the cells contained in "View Filter" (i.e. Phase, or Sub-Phase), is it really necessary to tell the program where it should stop when coloring the rows?
I would imagine once it no longer sees Phase or Sub-Phase, it is no longer trying to color anything.

However! I have had some very minimal experience with other people's macros (before I decided I should start to try this myself. and my previous experience was at a previous employer- so there's no asking for help other than on here ). I do recall a colleague had a macro that did something similar- but was not coloring rows, but just individual cells. Sometimes, when I or someone else would run it- it would freeze up. And when it would finally come to, the macro colored a ton of empty cells that were completely unnecessary.

Perhaps that is why you have explained the above?
Either way, I have included it- tested it, and it didn't cause any issues- so we're good to proceed

For the most part, I understand- as much as I can understand with no prior knowledge of the language of a programmer, or knowledge of macros in general. I am big on trial and error, but I need a stepping stone to even allow me to perform a trial. Then I can troubleshoot after I have a basic understanding.

So I am picking up what you're laying down, but at the same time, I might not be able to pick up all of it. I'm picking up what I can, and applying it, and it's a good starting point. I am making those comments in there so I can refer back some day- so that is helpful. From there, if I ever get stuck, I can resort to the wonderful world of Google- which is what brought me here to begin with!
Reply With Quote