+OFFSET and COUNTA in VBA

[Baphomay]

Hi,

I have been using some VBA code to define and name ranges when a workbook is opened, but I've come to a dead end with one of the Dynamic Lists, just wandering if the following line could be converted to "VBA"?
It refers to a Dynamic list called "VendorListDynamic", with sheets called "vendor" and "partslist".

Please Login or Register  to view this content.

and this is an example of the other code that I am using to name the ranges, this one defines a range and names is "suppliercostslist", using the Sheet "VendorInCosts".

Please Login or Register  to view this content.

thanks for any help

Graham

[GC Excel]

Hi Baphony
First comment : avoid using .Activate and .Select as it slows down your code. Most of the time you don't need to use it.

Here's an example, if I understood well :

Please Login or Register  to view this content.

[Baphomay]

Thank you very much GC Excel,

It worked!!!!!!! I'd been trying a couple of weeks to work it out, so thank you and - also want to thank you for the information about the Activate and Select statements, that has saved me extra lines of code

Graham