| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use CopyFromRecordSet to insert named range formulas? (Excel 2000)
I am trying to insert a recordset into an Excel worksheet using
CopyFromRecordset. I was hoping for certain cells that my query could simply insert the text of a named range formula as below: UPC Calculated Value Of Some Sort Quantity Row 00300300303 =GetValueFormula 5 The named range is simply ending up as text in the cell. Is there any way to do what I'm trying to do? Thanks. -- --------------------------------------------------------------- Kel Good MCT, MCAD, MCSD for Microsoft.NET |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Find formulas that use a named range | Excel Discussion (Misc queries) | |||
| Insert Named Range Into a Cell | Excel Worksheet Functions | |||
| Vlookup using a reference to a named range?(Excel 2000) | Excel Discussion (Misc queries) | |||
| INSERT into named range using ADO | Excel Programming | |||
| Insert named range problem | Excel Programming | |||
Threaded Mode
