Need to sum above the active cell until bold

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!

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.)

attach please a sample file with data and desired result

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

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

Formula:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, elpoder,

the range being used for the sample is like

Formula:

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