passing a range name as a variable results in error 1004

[darahsten]

Dear All,

I am trying to dynamically access certain values from a sheet (store) from a dynamic ranges.

I have a store into which raw materials are recorded with their expiry dates.
Each material could have several different batches with different expiry dates. My goal is to comb all these to ensure that for each batch in the store the products are not expired or are not about to expire.

Because i have like 8 raw materials each which has an indeterminate number of active batches. Writing static code looks like a job which can take as many as three days. Because of my consistent naming of ranges (A_Expiry, A_Batch, B_Expiry, B_Batch) I decided to access these named ranges using a variable

Please Login or Register  to view this content.

NOte ExpDate should recieve an array.
Yes and the names of the range are valid and the variables translate correctly to the names of ranges
Any body with any idea. Line with error is in code in bold

[TMS]

Suggest you post a sample workbook with named ranges and code.


Regards, TMS

[darahsten]

TMShucks, thanks for the quick reply there. I gues i was just tired and couldnt think or may be wanted some support. It turned out to be an issue with naming after all. I tested the code in isolation (another template) and it worked showing me that the problem was with my template. Some of my names have special characters which excel rejected and for which i created modifications such as (_). I just have to track these modifications.

Thank you again

[TMS]

Fair enough, glad you have resolved the issue.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.