NeVeR Posted February 5, 2013 Report Share Posted February 5, 2013 I've a list of numbers that i'd like to copy. Each number is on it's own line in a spread sheet. I'd like each number once copied to be give a %T1% and then %T2% for the second and so on. So each number has it's own %T% number. The list of numbers i've to copy changes all the time. So when i start the marco i'd like to get a prompt saying "How many times to repeat" I'd enter a value and then the macro would know how many times to run. I'm sure I can get this part done ( I hope ) It's the setting each copied number to it's own %T% that i can't figure out. I know i could do this the long way of just duplicating a command 10 or 20 times in ME and then repeating it by hand .. but i don't really want to as i'm sure there is a way around it. Any idea ? What i have so far is Set Var Interger %N!% from prompt // I will enter the repeat amounts here Repeat with Var using N1 / repeat will start. Clipboard copy Var set string %T!% from clipboard -------------- How do i get this part to move to %T2% and then %T3% etc each new time the repeat is run ? there is more to it but this is the main part i'm stuck on. thanks. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.