Selecting a named range in VBA code

Hi guys,

I have a template spreadsheet which has a macro in it that is accessed from another workbook. This template will eventially be about 30 different workbooks. I have this code:

Please Login or Register  to view this content.

I need the code on the line where it selects the "AFBP_text.xls" to select a range from a page in the workbook. The range is "Scriptname" and will be in every workbook.

Obviously the scriptname range will change for each workbook, but the macro needs to run the same. So instead of manually changing which workbook it selects in the code for each new workbook I create from the template, I'm wondering if there is code to connect to this range automatically?

Thank you in advance!

Matt

have you tried

Please Login or Register  to view this content.

?

Your code is quite horrid (no personal insult, I'm sure you yourself are fully lovely). Perhaps you should google "writing better VBA".

CC

Originally Posted by Cheeky Charlie

have you tried

Please Login or Register  to view this content.

?

Your code is quite horrid (no personal insult, I'm sure you yourself are fully lovely). Perhaps you should google "writing better VBA".

CC

Code seems to be generated by the macro recorder :P

agreed.

Doesn't mean it has to stay horrid!

The code is horrid your right, it's a case of inheriting alot from previous users and also recording macro's to save time. It does the job, once I have everything in place I'll go through the code and tidy it up. To be honest, my job isn't to do this, I'm tidying up and saving time for current users on about 30 different main templates - then I do my own job. Which is why I ask you guys a fare few questions...

So...

Thank you very much for your continued help, I'm now going to type "writing better VBA" in google.

Matt

hehe!

I think I provided the solution you originally asked for - could you mark the thread as solved?

CC