AutoSum (via macro): result in bold

**bristly** · 06-26-2012, 06:16 AM

Hi,
I use a macro for AutoSum, so that I can trigger it by custom shortcut. (The original ALT+= didn't work for me - probably disabled by a keyboard tool I'm using).
This is the code (not from my head, so I don't understand it completely, to be honest):

Please Login or Register  to view this content.

Now, it would be nice to have the result in bold, since this is the first thing I do manually all the time after running the macro.
Any help would be appreciated.

**tom1977** · 06-26-2012, 06:57 AM

Hi try this

Please Login or Register  to view this content.

You can use Alt + = instead this code

**bristly** · 06-26-2012, 07:29 AM

Hi, thanks.

It's almost what I need. But the bold cell position is not always where expected.

Let's say I have a range a1:c3. The behavior goes like this:
A4 selected - macro triggered -> A4 = bold sum of column A - ok
D1 selected - macro triggered -> D1 = bold sum of row 1 - ok
A1:C3 selected - macro triggered -> A4:C4 sums of all columns - last selected cell bold - ko
A1:C4 selected - macro triggered -> D1:D4 sums of all rows - last selected cell bold - ko

Alt + = doesn't work for me - I discussed it here and haven't figured out.