(Solved) – VBA that will pull a formula down until it hits a blue cell?

  • by
(solved)-–-vba-that-will-pull-a-formula-down-until-it-hits-a-blue-cell?

Is that possible? In cell B5 I put the number 1, then in B6 I put =B5 1 so that it reads 2, then I want that formula to go down until the end of the report which results in a row of blue cells. However, our reports always have a different number of lines.

Basically, the report runs out with a total line at the bottom, which is filled with dark blue. I want to, in column B, count how many rows until we hit that blue cell. There is no value or text in the blue cell though.

Leave a Reply

Your email address will not be published. Required fields are marked *