Pasting data onto Sheet

[twosides]

I am using 'Dim' to define a string for SheetName, a variable.

I have tried with no success various ways to try and paste data to a sheet with this variable.
I know the variable is correct as I am using it to make a new sheet then rename it and also move it.

The code I have used I have edited several time but still with no luck.
I have tried:

Please Login or Register  to view this content.

and also:

Please Login or Register  to view this content.

Still with no luck. I know I must be close but have searched this forum and found no similar answers.


Any help would be really appreciated folks.

Thanks.

[davesexcel]

You probably need to paste the row to a cell, not to a row

[shg]

You can use either of these forms:

Please Login or Register  to view this content.

[twosides]

It still does not work. I am using a command button to run this code.

It working correctly right up to the 'paste' line of code.

Please Login or Register  to view this content.

Cheers folks

[shg]

Please Login or Register  to view this content.

[twosides]

Thanks for the reply.
I have used the above code but nothing is being pasted into the destination sheet.

What am I doing wrong? Its driving me mad because I feel sure I am close to solving it.

[davesexcel]

Try this

Please Login or Register  to view this content.

[twosides]

Hi Dave,
It works but copies everything from line 1 to 5 and not everything line 5 onwards.

I have put in a 'MsgBox f' after the f = ws.Range......line to see what value of 'f' is being carried forward and it just says 1.

Any ideas?

Thanks

[davesexcel]

Hi Dave,
It works but copies everything from line 1 to 5 and not everything line 5 onwards.

I have put in a 'MsgBox f' after the f = ws.Range......line to see what value of 'f' is being carried forward and it just says 1.

Any ideas?

Thanks

yes, you must have nothing in columnA
This will find the last row in the worksheet

Please Login or Register  to view this content.

[twosides]

Job Done.
Fantastic. Thanks for your help