hi i i need to copy cells A1:C10, and paste them X times. The X is in the cell D1, also in the cell A1 i have a formula =IF('C:\Users\..\..\\E kompletuar\[data.xlsx]data'!$H$2=0;"") I need the Cell row $H$2 to change by the number of times the cells A1:C10 is pasted. eg. $H$3 (if i paste for first time), $H$4 (if i paste for second time),$H$5 (if i paste for third time) ... Please some one to help me

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

copy and Paste cells x times

Thread starter vivis93
Start date Oct 12, 2015
Tags

copy & paste row change vba

vivis93

New Member

Oct 12, 2015

hi i i need to copy cells A1:C10, and paste them X times. The X is in the cell D1, also in the cell A1 i have a formula

Code:

=IF('C:\Users\..\..\\E kompletuar\[data.xlsx]data'![B]$H$2[/B]=0;"")

I need the Cell row $H$2 to change by the number of times the cells A1:C10 is pasted. eg. $H$3 (if i paste for first time), $H$4 (if i paste for second time),$H$5 (if i paste for third time) ...

Please some one to help me