Pasting infomation into worksheet with macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce64 - 21 Nov 2007 03:38 GMT

Using a macro within a workbook, I am wishing to paste information from other
worksheets into an existing work sheet which already contains rows of data.
The macro should be able to determine the first empty row and then paste. I
cannot determine which function to use and how?

Signature

Bruce

Reply to this Message

Steve Schapel - 21 Nov 2007 07:37 GMT

Bruce,

The focus of this newsgroup is on Macros in Access, the database
programme. Access macros and Excel macros are quite different
creatures. You will have a better chance of a good answwer in an Excel
related newsgroup.

Signature

Steve Schapel, Microsoft Access MVP

> Using a macro within a workbook, I am wishing to paste information from other
> worksheets into an existing work sheet which already contains rows of data.
> The macro should be able to determine the first empty row and then paste. I
> cannot determine which function to use and how?

Reply to this Message

Bruce64 - 21 Nov 2007 10:08 GMT

Thanks for yr advise

Signature

Bruce

> Bruce,
>
[quoted text clipped - 7 lines]
> > The macro should be able to determine the first empty row and then paste. I
> > cannot determine which function to use and how?

Reply to this Message