it might be too difficult to explain in an email - if you have a quick second
please call me 877-546-6757. If not, what I am doing is dropping client
information from a database called fasttrak, onto an excel spreadsheet. It is
a client list of over 1300 clients. I am trying to run a macro that will move
the information into the appropriate columns for me with a push of a button,
however to record this macro i would need to cut a number of cells on the
same row and paste them to a number of cells in a row above and to the right
of the row i just cut. Then i would need to repeat the process.
" wrote:
hi,
I don't think you want to use the cut paste method several
thousand times in a macro. that will cause you memory
problems and your macro will crash with out of memory
messages.
I suggesst you find another method to do this.
repost with what you are trying to do.
-----Original Message-----
i want to repeat the same cut paste method over and over
several thousand
times without having to do it manually while recording my
macro. Is there a
way to repeat this function.
.
|