hidden location for range properties?

[Eric Kelcher]

I have a program that ACW helped me with years ago(pretty sure it was Excel 2003 aka v11, currently on Office 365) that does a look up and converts name to its corresponding item code. This uses a range named "lurange". I am now running into an issue it appears that "lurange" is defined as lines 1-69 and I have now exceeded 69 items and for the life of me I cannot find where the range for "lurange" is defined.

Is there a hidden location that I should be investigating or something I am missing on why items beyond line 69 are not working?

 

[Fluff]

It would help if you were to post the code that you are using.

 

[RoryA]

Have you checked the definition of the name lurange in the Name Manager on the Formulas tab?

 

[Eric Kelcher]

Fluff,

The full VBA program is in excess of 10,000 lines and has 25 sub macros over 25 worksheets. aka too big and too many places to hide definitions

 

[Eric Kelcher]

Rory,

That is IT!!! perfect, problem solved; it was defined as $J$1:$K$69

I expanded it to K$100

 

[Eric Kelcher]

Having an issue with this when sharing macro to other machines, is there a way to define range in macro or do I have to define the range on each computer that I have a macro that uses range?