How to "push" a value into a cell

[Debra Dalgleish]

Yes, and that's why I suggested that he name the range "Database"

 

[Ken Wright]

OK forget that, it was A1:B2 it had to start in, but this was negated by
defining the range with the name 'database' - I'll shut up now

http://support.microsoft.com/default.aspx?scid=KB;en-us;q110462

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Debra, just a thought, but wasn't there an issue in earlier versions where if
the database range did not start on any of the first 2 rows, then it didn't like
it. I seem to remember I had a similar issue with a post recently and am sure
it was one of your posts that put me straight. A possibility perhaps?

<snip>

 

[Ken Wright]

rotflmao - Found the damn post shortly after and realised exactly that :-(

 

[Mark Flaxman]

Yippeeeee !!!!!!!!!!!!!!!

It works Debra, many, many thanks, )

I can now move on and continue developing the spreadsheet.

I know I really must learn VBA programming. If I had had
a smidgeon of knowledge I would perhaps have picked up
that the last Worksheet term had to remain as Worksheet,
and not the name I have given it.

Again, many thanks to you especially, and to Ken.

(I haven't read the other posts yet. will do that now.)

Mark Flaxman

 

[Mark Flaxman]

LOL

Finishing this thread off with thanks

Mark Flaxman

 

[Debra Dalgleish]

Mark,

You're welcome! Thanks for reporting that you've got it working, and
good luck with the rest of the spreadsheet.

Debra