Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
INSERT into named range using ADO
Hi,
I've got a spreadsheet with several named ranges that I'm going to dump some data in from SQL server. I've got most of it working, but I've run into one problem! In some of the ranges, I don't want the first block to be treated as the headers. For example. I have the first two cells of the spreadsheet A1 and A2 as a named range called 'Titles'. Into these two cells I am inserting a name and date. I would like to be able to insert directly into the top row of the named range, not have it insert the data beneath the first row in the range. Is this possible? If so, how would I accomplish this? Regards, Tim. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Named Range Into a Cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Insert named range problem | Excel Programming |