Copy and paste from one worksheet to another worksheet macro problem

[Kerbazee]

Hi!

New to VBA, Excel 2010, Calculation option set to manual (Sorry if I missed any info needed)

I have made a macro that with a click of a button gets some values of a formula from one worksheet and pastes them in another worksheet and my problem is that when I press the button again it just overwrites values from the first row instead of pasting them on a new row.

Please Login or Register  to view this content.

Thanks in advance for any help

Regards, Zebastian Luthin

[HaHoBe]

Hi, Kerbazee,

get the first empty row in Column A on Sheet Draw and pass the values. If you insert a formula into F2 on Draw it will keep the value as long as the workbook is not calculated but adapt to the new value on every calculation (and on saving).

Maybe try this code:

Please Login or Register  to view this content.

Ciao,
Holger

[Kerbazee]

Works like a charm! Thanks man!

Another question, is there a way to run that a 1000 times without clicking the button 1000 times just want to see if my random numbers are unique.

[HaHoBe]

Hi, Kerbazee,

IŽd go away from a certain number for running the loop and go for an open loop which would end when you finally reached what you are after (this might take more than 1000 times). So instead of using

Please Login or Register  to view this content.

I would use WorksheetFunction.Countif to check the range and the number and only copy over when a new value has been found.

Please Login or Register  to view this content.

This is just a descrition - if you need help on getting the code for it please feel free to come back and ask.

Ciao,
Holger

[Kerbazee]

Hey HaHoBe!

Thanks for the help man I figured it out with your help!

Cheers
//Kerbazee