Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel macros
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. |
#2
|
|||
|
|||
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. . |
#3
|
|||
|
|||
Hi there,
There are more efficient methods to accomplish what it is you are asking than using Cut/Paste method. If you describe in detail what it is you are trying to accomplish then a far better solution may present itself. Please post any relevant code, and describe your data structure in detail. -- Regards, Zack Barresse, aka firefytr "cleve mc daniel" <cleve mc wrote in 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. |
#4
|
|||
|
|||
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. . |
#5
|
|||
|
|||
I wrote more specifics - please let me know what you think
"zackb" wrote: Hi there, There are more efficient methods to accomplish what it is you are asking than using Cut/Paste method. If you describe in detail what it is you are trying to accomplish then a far better solution may present itself. Please post any relevant code, and describe your data structure in detail. -- Regards, Zack Barresse, aka firefytr "cleve mc daniel" <cleve mc wrote in 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. |
#6
|
|||
|
|||
Yes, this is possible, even pretty easy.
But if your raw data is real "data" as in one complete record on a single row, you should try to keep it that way in Excel too. Data lose functionality the second relative physical location start to mean something. HTH. Best wishes Harald "cleve mc daniel" skrev i melding ... 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
help with excel (maybe macros) | Excel Worksheet Functions | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
how can i edit excel 4 macros in Excel 2003 | Excel Worksheet Functions | |||
Is there a way to sort by color in excel? using macros? | Excel Worksheet Functions |