INSERT into named range using ADO
What does your current code look like?
On Thu, 27 Jan 2005 18:47:25 -0000, "Tim Payne" wrote:
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.
|