I believe my code already answers your questions.

--
Regards,
Tom Ogilvy


"Hein" wrote in message
...

Thanks Vacation's over and Tom for your answers!

Maybe we are looking for a too complicated answer?

I've been thinking since my last post (quite a headache now ;-) ) and
maybe the answer isn't so complicated.

If you have a line of filled cells (e.g. in a column) you can go to the
last cell by either using <<end-arrow down of by using << ctrl-arrow
down.
Do any of you guys know to capture this in VBA?

2nd question. Sometimes the line of cells is interrupted by a blank
cell. To be sure to not miss a cell: is it possible to stop the macro
after the above mentioned <<ctrl-arrow down part so that I have the
change to include more cells after the blank cell, and using the enter
key continues the code??

If I can pull this off I'm sure I can get it working.

By the way vacation's over: the reason for my asking this question is
that I have to do this trick several hunderds of times, maybe over a
thousand. Just typing the formula takes a lot of time!

Thanks for any help
Hein


--
Hein
------------------------------------------------------------------------
Hein's Profile:
http://www.excelforum.com/member.php...o&userid=24744
View this thread: http://www.excelforum.com/showthread...hreadid=474730