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

Excel Excel down arrow macro problem 1
Msgbox - number of rows pasted and time 2
Excel Macro for deleting Rows containing dates greater than "today" 0
Append Query Issue 0
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Excel Add rows automatically in excel 3
Macro for Varying Number of Rows 0
Print macro that hides rows before printing 1

Top