Thread: excel macros
View Single Post
  #4   Report Post  
cleve mc daniel
 
Posts: n/a
Default

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