Need to know number of rows pasted

T

Tiff

When a macro is used to run a make table query, is there anyway to get the
message box to tell me the count as it would if I had not turned off the
warnings?

thank you

tiff
 
S

Steve Schapel

Tiff,

Yes. After the Make-table has run, you can use a MsgBox action in your
macro, with the Message Text set to:
=DCount("*","NameOfTable")
 

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

Msgbox - number of rows pasted and time 2
Need Help with Macro Security 1
Select Text to End of Footnote 9
Creating a Search using a combo box and then creating a report. 4
Setting column width in a table with a macro is not working 0
Macro to copy table of contents to a new doc 0
Need some PWA help 0
Excel suddenly crippled by Just-In-Time Debugging 2

Top