How can I show the number of rows pasted by a macro?

T

Tiff

I have created a macro that autopastes the rows but need to know how many
rows I am autopasting.

thank you

tiff
 
J

Jeff Boyce

Tiff

"... that autopastes the rows ... "

What rows? What is the source of what you are pasting?

--

Regards

Jeff Boyce
Microsoft Access MVP
 
T

Tiff

The rows are as a result of a make table query which has date parameters.
The table we are running it from are from a linked table.

thank you

tiff
 
J

John W. Vinson

The rows are as a result of a make table query which has date parameters.
The table we are running it from are from a linked table.
Click to expand...

Use VBA instead of a Macro, and use the Execute method; this gives you a
RecordsAffected property. See the VBA help for RecordsAffected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
Need Help with Macro Security 1
Change a great number of words in word files, with a macro as short as possible. 5
Copy addition formula of non-consecutive horizontal cells 2
Drop down list control value in vba 2
Need Help with a VBA subroutine 0
How can paste the content in some of row into some of collumn? 0
How do I stop the autopaste function in Excel? 1

Top