Please modify my VBA, I want copy paste in next sheet

[vengatvj]

Hi,
I want copy A to I column data, and I need to paste in second sheet. I tried in macro recording, but my problem is my VBA only copy "A1:I10" Data,

Some times I need to copy more data, But my vba only copy first 10 cell data only. how to modify this vba?

Please Login or Register  to view this content.

[Mumps1]

Your current code copies A1:I10 and then pastes it. What is the exact range you want to copy and where in the second sheet do you want to copy it to?

[Solus Rankin]

Like this?

Please Login or Register  to view this content.

[mehmetcik]

This should work

Please Login or Register  to view this content.

This should also work

Please Login or Register  to view this content.

[/CODE]

[vengatvj]

Solus Rankin, your code copy only first 8 cells, see my sample excel

[mehmetcik]

This should work

Please Login or Register  to view this content.

This should also work

Please Login or Register  to view this content.

[vengatvj]

Hi all, see my sample file, some time my data will be more than 100 data, i give just 10 data in sample file. please., see and tell me the solution,

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[vengatvj]

Hi John H.DAVIS, your formula copying whole row data to next sheet. I want copy only A TO I column data and count may be variable in any time. kindly make it only copy A to I data

[Mumps1]

Try:

Please Login or Register  to view this content.

[AB33]

Another one

Please Login or Register  to view this content.

[vengatvj]

Very thank to Mumps1, AB33. Your Program working well. Thank you so much again...

[Mumps1]

Glad it worked out.