I'm using this code to add a column total, what do I need to add to centre the number in the cell and to format it using a comma for thousands?
Many thanksPlease Login or Register to view this content.
I'm using this code to add a column total, what do I need to add to centre the number in the cell and to format it using a comma for thousands?
Many thanksPlease Login or Register to view this content.
If you record it with the macro recorder you will get the code.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi oeldere,
Okay, I now have this, which works, but is there a more 'efficient' way to write this, with fewer lines of code or is this the best way? I basically want the last row only to be formatted as bold and with the numeric value in column D to include the comma for thousands and be centred, but the word 'Total' in column C to be left ranged.
Many thanks
Please Login or Register to view this content.
more 'efficient' way to write this, with fewer lines of code or is this the best way?
Probably there is, but I don't have the solution for that.
But fewer lines are not always a better code.
A code you can understand is more usefull, than a code, which is shorter, but is magic for you.
Okay, that's good to know. The code works, which is the key point, so many thanks for your help...
Thanks for the reply.
Glad I could help.
You can use With blocks but it's not more efficient
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks