Old macro breaks!

I've been running a series of macros without problems for months. When
I made some major modifications to another macro in the same project,
all these macros stopped working, even though the macro I was modifying
and these macros don't call or relate to each other. The only
connection is that they use the same range and varable name for that
range.

Sub Top10()

ActiveSheet.Range("rFltrRng").AdvancedFilter
Action:=xlFilterInPlace, CriteriaRange:= _
Range("Z1:Z2"), Unique:=False
Range("a1").Select

End Sub

I've tried using a different name for "rFltrRng" to separate it from
the other variable in the other macro.
Any ideas?
Thanks

rFltrRng isn't a variable. It is a string constant. Used in the context
you present, it represents the name of a range in Insert=>Name=>Define.

You need to go to Insert=>Name=>Define and see what the current refers to
Range definition is. If it isn't what you expect, then you need to figure
out how it is getting changed.

--
Regards,
Tom Ogilvy

"davegb" <davegb@safebrowse.com> wrote in message
news:1120835674.830788.161050@o13g2000cwo.googlegroups.com...
> I've been running a series of macros without problems for months. When
> I made some major modifications to another macro in the same project,
> all these macros stopped working, even though the macro I was modifying
> and these macros don't call or relate to each other. The only
> connection is that they use the same range and varable name for that
> range.
>
> Sub Top10()
>
> ActiveSheet.Range("rFltrRng").AdvancedFilter
> Action:=xlFilterInPlace, CriteriaRange:= _
> Range("Z1:Z2"), Unique:=False
> Range("a1").Select
>
> End Sub
>
> I've tried using a different name for "rFltrRng" to separate it from
> the other variable in the other macro.
> Any ideas?
> Thanks
>

Do you have "Option Explicit" at the top of your macro modules?
This forces Excel to alert you when there are certain problems with your
code:
variables that are not recognized; variables not defined correctly, etc.

Please supply more info on the nature of the any errors that come up.
Type, line of code(s) that fails, etc...

--
steveB

Remove "AYN" from email to respond
"davegb" <davegb@safebrowse.com> wrote in message
news:1120835674.830788.161050@o13g2000cwo.googlegroups.com...
> I've been running a series of macros without problems for months. When
> I made some major modifications to another macro in the same project,
> all these macros stopped working, even though the macro I was modifying
> and these macros don't call or relate to each other. The only
> connection is that they use the same range and varable name for that
> range.
>
> Sub Top10()
>
> ActiveSheet.Range("rFltrRng").AdvancedFilter
> Action:=xlFilterInPlace, CriteriaRange:= _
> Range("Z1:Z2"), Unique:=False
> Range("a1").Select
>
> End Sub
>
> I've tried using a different name for "rFltrRng" to separate it from
> the other variable in the other macro.
> Any ideas?
> Thanks
>

Thanks, Tom, that helped me track down the problem.

Tom Ogilvy wrote:
> rFltrRng isn't a variable. It is a string constant. Used in the context
> you present, it represents the name of a range in Insert=>Name=>Define.
>
> You need to go to Insert=>Name=>Define and see what the current refers to
> Range definition is. If it isn't what you expect, then you need to figure
> out how it is getting changed.
>
> --
> Regards,
> Tom Ogilvy
>
> "davegb" <davegb@safebrowse.com> wrote in message
> news:1120835674.830788.161050@o13g2000cwo.googlegroups.com...
> > I've been running a series of macros without problems for months. When
> > I made some major modifications to another macro in the same project,
> > all these macros stopped working, even though the macro I was modifying
> > and these macros don't call or relate to each other. The only
> > connection is that they use the same range and varable name for that
> > range.
> >
> > Sub Top10()
> >
> > ActiveSheet.Range("rFltrRng").AdvancedFilter
> > Action:=xlFilterInPlace, CriteriaRange:= _
> > Range("Z1:Z2"), Unique:=False
> > Range("a1").Select
> >
> > End Sub
> >
> > I've tried using a different name for "rFltrRng" to separate it from
> > the other variable in the other macro.
> > Any ideas?
> > Thanks
> >

STEVE BELL wrote:
> Do you have "Option Explicit" at the top of your macro modules?

Yes

> This forces Excel to alert you when there are certain problems with your
> code:
> variables that are not recognized; variables not defined correctly, etc.
>
> Please supply more info on the nature of the any errors that come up.
> Type, line of code(s) that fails, etc...
Thanks for the help, Steve!