<div>
Hi,<br />
<br />
If the Workbook is already open<br />
<br />
set wb = Workbooks(&quot;myWorkbook.xlsm<wbr />&quot;)<br />
intersect(wb.activesheet.u<wbr />sedrange,R<wbr />ange(&quot;A:G&quot;<wbr />)).Special<wbr />Cells(xlCe<wbr />llTypeVisi<wbr />ble).Name = &quot;TheName&quot; <br />
<br />
Regards
</div>


Hi,

If the Workbook is already open

set wb = Workbooks("myWorkbook.xlsm")
intersect(wb.activesheet.usedrange,Range("A:G")).SpecialCells(xlCellTypeVisible).Name = "TheName"

Regards

<div>
Clarify what you mean by remote. Is it on a network and will it be open?
</div>


Clarify what you mean by remote. Is it on a network and will it be open?

<div>
the sheet is open on the local computer <br />
it works if I place the code in the same workbook<br />
<br />
if tied to a sheet in another workbook<br />
I receive the error:<br />
<br />
Run-time error 1004<br />
Application-defined or Object-defined error<br />
<br />
or in a module within a separate workbook:<br />
Run-time error 1004<br />
Method 'Intersect' of object '_Global failed
</div>


the sheet is open on the local computer
it works if I place the code in the same workbook

if tied to a sheet in another workbook
I receive the error:

Run-time error 1004
Application-defined or Object-defined error

or in a module within a separate workbook:
Run-time error 1004
Method 'Intersect' of object '_Global failed

<div>
<div class="content wysiwyg-content">
To create a named range within the active workbook/sheet I use:<br />
<br />
intersect(activesheet.used<wbr />range,Rang<wbr />e(&quot;A:G&quot;)).<wbr />SpecialCel<wbr />ls(xlCellT<wbr />ypeVisible<wbr />).Name = &quot;TheName&quot; <br />
<br />
How could I modify this to create a named range for the used cells in a worksheet within a remote workbook
</div>
</div>


To create a named range within the active workbook/sheet I use:

intersect(activesheet.usedrange,Range("A:G")).SpecialCells(xlCellTypeVisible).Name = "TheName" 

How could I modify this to create a named range for the used cells in a worksheet within a remote workbook

How to create a named range in a remote workbook/worksheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.