Combine codes into one macro

Hi,

I'm very new to this. I have two codes I would like to combine for a single macro because I can't get the second code to run in Sheet 3. The first code is in the Sheet 3 View Code box.

Please Login or Register  to view this content.

and the second code is in a module created from Sheet 3.

Please Login or Register  to view this content.

Currently, the second code (in module 1) is not working on Sheet 3, but it does work on other sheets where I have it in the Sheet View Code box of the sheet.

When I look in the View Macro's box I see no macros. Am I missing a step or something?

Thanks,

Russ

Try removing the 'Private' then see if it works.

create another macro..that will call them all

Please Login or Register  to view this content.

Debraj,

Thanks for the help. It's working for the most part but the value of cell O152 changes when it should not. Cell O152 is formated "=A8". The second code should cause cell O152 to retain the first value returned and not change as the data entered in A8 changes. Each of these formulas work by themselves, but I can't get them to work together.

Can you help please,

Thanks.

Russ

Thanks Debraj,

Got the formula to work by changing A8 to $A$8.

Thanks for the advice. I really appreciate the help.

Russ