<div>
Actually<br />
<br />
Range(&quot;A1&quot;).Value = Sheets(&quot;MyHiddenSheetName&quot;<wbr />).Range(&quot;B<wbr />areMetal&quot;)<wbr />.Value<br />
<br />
Or, if this is for your personal use, forget about hiding the sheet and the named ranges, just copy and paste the values from the formerly hidden sheet.
</div>


Actually

Range("A1").Value = Sheets("MyHiddenSheetName").Range("BareMetal").Value

Or, if this is for your personal use, forget about hiding the sheet and the named ranges, just copy and paste the values from the formerly hidden sheet.

<div>
You're welcome and I'm glad I was able to help.<br />
<br />
Marty - MVP 2009 to 2013
</div>


You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I do invoices in excel. <br />
<br />
Is there any way to have a bit of excel remember snippets of commonly used text<br />
<br />
for example a bare metal install invoice ........ <br />
<br />
Copy data<br />
restored windows<br />
installed updates <br />
Restored data <br />
<br />
I dont want to have to type this every time. <br />
<br />
Aside from having a notepad of these is there a way to call this into excel? <br />
Is there an inbuilt notepad in excel for the likes of this? <br />
<br />
Thanks,
</div>
</div>


Hi,

I do invoices in excel. 

Is there any way to have a bit of excel remember snippets of commonly used text

for example a bare metal install invoice ........ 

Copy data
restored windows
installed updates 
Restored data 

I dont want to have to type this every time. 

Aside from having a notepad of these is there a way to call this into excel? 
Is there an inbuilt notepad in excel for the likes of this? 

Thanks,

Excel &gt; Calling up &quot;snippets&quot;  (something like that) - a paste &quot;file&quot; of commonly used text ...

Wireless networking is anything related to the transfer of data between two (or more) devices without the use of a physical connection, ranging from getting advice on a new Bluetooth headset to configuring sophisticated enterprise level networks.

Wireless Networking

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Excel &gt; Calling up &quot;snippets&quot; (something like that) - a paste &quot;file&quot; of commonly used text ...

Excel > Calling up "snippets" (something like that) - a paste "file" of commonly used text ...