How to "push" a value into a cell

  • Thread starter Thread starter Mark Flaxman
  • Start date Start date
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 :-)
----------------------------------------------------------------------------



Ken Wright said:
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?
Click to expand...
<snip>
 
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,

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

Debra
 
Back
Top