Hello,
as titled states, is there a way to auto sum everything on the left ? These are borders and not tables.
Something like this
Untitled.png
Hello,
as titled states, is there a way to auto sum everything on the left ? These are borders and not tables.
Something like this
Untitled.png
I'm not much use with VBA. However, I don't see how this can be done - even with VBA. The nearest I do is a UDF that sums all cells in a range with FULL borders. Put the code in a module in the sheet (right click on sheet name/view code/INSERT/MODULE and save as Excel enabled.
I know this isn't quite what you asked for, but I don't know how Excel could differentiate between the two green-shaded cells in the attached file, if only the outer borders were present. Both cells would then have a border top & left. Maybe someone else will do it exactly as you require...Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I'll give this a try
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks