Need to sum above the active cell until bold

[elpoder]

Hi,

Ive been trying to change the code related to post http://www.excelforum.com/excel-gene...ntil-bold.html in order to sum above the active cell until it hits a bold cell.
Currently the code sums below the active cell until it finds a bold one.

Please Login or Register  to view this content.

I've tried changing it to:

Please Login or Register  to view this content.

with no success.

Can anyone help me or explain me where to start?

Thanks in advance!

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(Added this time. Please read the rules and adhere to them.)

[elpoder]

Sorry, It will not happen again. Thank you.

[patel45]

attach please a sample file with data and desired result

[HaHoBe]

Hi, elpoder,

you must alter the logic from going down until a cell is bold to to start from when a cell is bold.

Maybe try:

Please Login or Register  to view this content.

Ciao,
Holger

[elpoder]

I appreciate the code provided by HaHoBe, but it's still not working.

I'm attaching the excel sheet for more details. I hope this will be more helpful.

Thank you!

[HaHoBe]

Hi, elpoder,

I hope this will be more helpful.

Sorry but not for me as I see only a nomal sum function in the cells. Maybe you could just use a different formula like

Please Login or Register  to view this content.

Ciao,
Holger

[HaHoBe]

Hi, elpoder,

the range being used for the sample is like

Please Login or Register  to view this content.

for C6 and should be starting with C1 as well for the other cells.

UDF being used:

Please Login or Register  to view this content.

Ciao,
Holger

[elpoder]

Hi Holger,

I really appreciate your time and excel expertise. It worked out perfectly!