I need some help accessing a named range. the range is on a sheet in a
addin I can call it with no problem from a module in the addin however
now need to access it form a module iether in another addin or from th
open workbook How do I do this. thanks
Ro

--
Message posted from http://www.ExcelForum.com

You can refer to that range just like any other range:

Dim myRng As Range
With Workbooks("YourAddinName.xla").Worksheets("YourWorksheetName")
Set myRng = .Range("a1:e" & .Cells(.Rows.Count, "A").End(xlUp).Row)
End With

This example used A1:E(last used row in column A).

Then do pretty much anything you want with it.

"rjtaylor <" wrote:
>
> I need some help accessing a named range. the range is on a sheet in an
> addin I can call it with no problem from a module in the addin however I
> now need to access it form a module iether in another addin or from the
> open workbook How do I do this. thanks
> Rod
>
> ---
> Message posted from http://www.ExcelForum.com/

--

Dave Peterson
(E-Mail Removed)

Do I have to use the set command. Normally i just refer to the rang
name allready set up on the workbook
i.e. Range("CONT_INT").Copy
thanks for the repla

--
Message posted from http://www.ExcelForum.com

That's fine, but I would think you'd need to include the workbook/addin name:

workbooks("myaddin.xla").worksheets("sheet1").range("cont_int").copy

(I like to include all the qualifiers, including the worksheet--even though it's
not always necessary.)

"rjtaylor <" wrote:
>
> Do I have to use the set command. Normally i just refer to the range
> name allready set up on the workbook
> i.e. Range("CONT_INT").Copy
> thanks for the replay
>
> ---
> Message posted from http://www.ExcelForum.com/

--

Dave Peterson
(E-Mail Removed)