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
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
Bookmarks