Adding "Lastrow" function to these formulas:

Hello,
I've been trying for a few hours now to add Lastrow Functionality to a formula I'm using as it's cycling through over 100,000 empty cells for each formula and making my Macro very very slow. My spreadsheet will have a highly variable number of rows.

Here's the formula I'm using, along with the Lastrow code that's served me will in the past:

Please Login or Register  to view this content.

For anyone who might what to know what this is for (bigger picture), I'm using this code from Ozgrid to count and sum based on font color:
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Thanks so much for everyone's help in advance. I've been working on this for too long, I think my brain is going numb (yet it doesn't seem that complicated...?)

I am just starting to learn VBA myself, but see if this code snippet will help (given to me by another member)...it finds the last row and goes down 1 more row

Please Login or Register  to view this content.

You aren't being very specific about what you are doing here. You show two lines of code, one selects a cell, which isn't necessary and slows down your code. Are you looping from cell to cell and putting this formula in the cells to the last row?
Your last row code looks in column G, but your formula is in column AB and references column C, so what are you doing that needs the last row?

Hi Chad,

You could also use this non R1C1 reference style (which in my humble opinion is much easier to read):

Please Login or Register  to view this content.

Hi Ford,

given to me by another member

Nice

Robert

This is perfect.
I can't thank you enough!

You're welcome

If you could mark the thread as solved it would be appreciated

Regards,

Robert