VB help! (1 Viewer)

[JOhnNiLiCiouS]

VB as in Visual Basic...

in microsoft excel, I want to copy a row to the bottom of another worksheet... how do i do it?

This is what I got...

Sub Copy()

Sheets("Sheet1").Select
Rows("13:13").Select
Selection.copy
Sheets("Sheet2").Select

// Set up while loop here... while the first cell is not empty, go down to next row...

ActiveSheet.Paste

End Sub


While ActiveCell <> ??


Thanks

 

[JOhnNiLiCiouS]

VB as in Visual Basic...

in microsoft excel, I want to copy a row to the bottom of another worksheet... how do i do it?

This is what I got...

Sub Copy()

Sheets("Sheet1").Select
Rows("13:13").Select
Selection.copy
Sheets("Sheet2").Select

// Set up while loop here... while the first cell is not empty, go down to next row...

ActiveSheet.Paste

End Sub


While ActiveCell <> ??


Thanks

bump!

 

[sunny]

I don't know it off the top of my head, but you can always record and macro then look at the VBA code.

 

[JOhnNiLiCiouS]

i tried that... but... how do you make it scroll down until empty cell??... i tried end... but didn't really work... :S