Too large-how do I split

[Daniel R. Young]

I have a very large marco that I want to split and make the macro smaller.
The code is in one sheet and I am very new to this. I was told to make to
macros and then use this:

Sub master ()
Macro1
Macro2
End Sub

How do split these two macros and where do I place the sub master? Does the
sub master go on the main sheet that I am using?

Can someone do a step by step for me? I would really appreciate it.

Thank you

Daniel

[Toppers]

Hi,
Send me your code and I'll look at it off-line.

[email protected]



"Daniel R. Young" wrote:

> I have a very large marco that I want to split and make the macro smaller.
> The code is in one sheet and I am very new to this. I was told to make to
> macros and then use this:
>
> Sub master ()
> Macro1
> Macro2
> End Sub
>
> How do split these two macros and where do I place the sub master? Does the
> sub master go on the main sheet that I am using?
>
> Can someone do a step by step for me? I would really appreciate it.
>
> Thank you
>
> Daniel

[Elizabeth]

Toppers:
If you provided Daniel with a solution, would you mind posting it to this
site. I too am new to VBA & would be very interested in your code. Thank
you.
Elizabeth

"Toppers" wrote:

> Hi,
> Send me your code and I'll look at it off-line.
>
> [email protected]
>
>
>
> "Daniel R. Young" wrote:
>
> > I have a very large marco that I want to split and make the macro smaller.
> > The code is in one sheet and I am very new to this. I was told to make to
> > macros and then use this:
> >
> > Sub master ()
> > Macro1
> > Macro2
> > End Sub
> >
> > How do split these two macros and where do I place the sub master? Does the
> > sub master go on the main sheet that I am using?
> >
> > Can someone do a step by step for me? I would really appreciate it.
> >
> > Thank you
> >
> > Daniel

[Toppers]

Hi,
I haven't got the code! but it was only a minor modification the
code supplied by Tom Ogilvy in the original postings so he should really get
the credit. The solution was as per Tom's post - simply loop through
(calculated) ranges rather have each individual range hard coded as per Dan's
original posting.

No magic solution!

HTH

"Elizabeth" wrote:

> Toppers:
> If you provided Daniel with a solution, would you mind posting it to this
> site. I too am new to VBA & would be very interested in your code. Thank
> you.
> Elizabeth
>
> "Toppers" wrote:
>
> > Hi,
> > Send me your code and I'll look at it off-line.
> >
> > [email protected]
> >
> >
> >
> > "Daniel R. Young" wrote:
> >
> > > I have a very large marco that I want to split and make the macro smaller.
> > > The code is in one sheet and I am very new to this. I was told to make to
> > > macros and then use this:
> > >
> > > Sub master ()
> > > Macro1
> > > Macro2
> > > End Sub
> > >
> > > How do split these two macros and where do I place the sub master? Does the
> > > sub master go on the main sheet that I am using?
> > >
> > > Can someone do a step by step for me? I would really appreciate it.
> > >
> > > Thank you
> > >
> > > Daniel

[Elizabeth]

Toppers:
Once again, I must admit to my newness. When you refer to "the
code supplied by Tom Ogilvy in the original postings", what do you mean,
what original postings? I don't see a Reply from Mr. Ogilvy. Thank you.
Elizabeth

"Toppers" wrote:

> Hi,
> I haven't got the code! but it was only a minor modification the
> code supplied by Tom Ogilvy in the original postings so he should really get
> the credit. The solution was as per Tom's post - simply loop through
> (calculated) ranges rather have each individual range hard coded as per Dan's
> original posting.
>
> No magic solution!
>
> HTH
>
> "Elizabeth" wrote:
>
> > Toppers:
> > If you provided Daniel with a solution, would you mind posting it to this
> > site. I too am new to VBA & would be very interested in your code. Thank
> > you.
> > Elizabeth
> >
> > "Toppers" wrote:
> >
> > > Hi,
> > > Send me your code and I'll look at it off-line.
> > >
> > > [email protected]
> > >
> > >
> > >
> > > "Daniel R. Young" wrote:
> > >
> > > > I have a very large marco that I want to split and make the macro smaller.
> > > > The code is in one sheet and I am very new to this. I was told to make to
> > > > macros and then use this:
> > > >
> > > > Sub master ()
> > > > Macro1
> > > > Macro2
> > > > End Sub
> > > >
> > > > How do split these two macros and where do I place the sub master? Does the
> > > > sub master go on the main sheet that I am using?
> > > >
> > > > Can someone do a step by step for me? I would really appreciate it.
> > > >
> > > > Thank you
> > > >
> > > > Daniel