Named ranges in the VBE
 

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

Named ranges in the VBE
 

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

--
---
HTH

Bob


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



"Matthew Pfluger" wrote in
message ...
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

Named ranges in the VBE
 

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

"Matthew Pfluger" wrote:

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