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.
 
Top