Thank you for taking your time to read my questions.
My question is the following any form of help will be greatly appreciated.
I am trying to use check boxes in order to copy and paste values over to another worksheet automatically.
This means multiple items need to append onto the other worksheet leaving a row between eachother.
Is there something i can do to make this work?
this is the code i am currently using, but instead of having a specified area of selection when copying too, i would like it to pick up the row below the last used row
Private Sub CheckBox1_Click()
Worksheets("WebADI").Range("C19:Q272").value = Worksheets("Allocation").Range("K9:Y262").value
End Sub
Private Sub CheckBox2_Click()
Worksheets("WebADI").Range("C274:Q536").value = Worksheets("Allocation").Range("K273:Y526").value
End Sub
thank you very much for your response its made a huge dent in what i am trying to do. It worked in regards to pasting the information over, however i will need to paste as values in order to stop all the formulas ref'ing out, can you please help me further in pasting the same code as values.
This will keep copied information in Excels memory. To clear memory use this after all pasting actions in the code:
application.cutcopymode = false
Using the macro recorder is a very handy tool to figure out how to do certain things in vba. So if for example you want to know how to paste format only, record macro, do the actions, stop recording and check the code.
This is just a general tip, so don't be afraid to ask here.
thank you very much for your response its made a huge dent in what i am trying to do. It worked in regards to pasting the information over, however i will need to paste as values in order to stop all the formulas ref'ing out, can you please help me further in pasting the same code as values.
Thank you Roy