Hi,

I have a macro which does exactly what I want apart from it's incredibly inefficient. I'm a bit basic when it comes to things likes this.

The code is as follow

Please Login or Register  to view this content.
I have a range controller for rows "LastT"

But as you can see the range for columns is "n to ho" which is massive and totally unnecessary as only a few of those columns are filled in.

My question is:

Is it possible for the code to only activate if say the count value in "n6:ho6" is greater than 0?

For example in my sheet right now only O6,AN6,AO6,AT6,AV6,BC6,BJ6,DP6 have values greater than 0 so I'd only want the macro to run for those columns instead of the whole range.

Any help would be much appreciated