Named ranges in the VBE

[Matthew Pfluger]

Does anyone know of an add-in or tool that allows you to insert Named
Variables? I'd like to be able to type in "Range("x")..." without having to
switch back to Excel and copy the name.

Any ideas, or do I have to build my own?

Matthew Pfluger

 

[Bob Phillips]

Range("A1:H10").Name = "SomeName"

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Matthew Pfluger]

Not quite. I am already familiar with this.

I mean more along the line of an add-in that keeps track of available named
ranges in the active module's workbook and allows you to quickly enter them
in, similar to using Ctrl+Spacebar for auto fill. Perhaps I should just
mention this to JKP and see what he thinks.

Matthew Pfluger