parttime_guy
05-20-2010, 10:46 PM
Two Flaps (A & B) - same formats.
If Cell below heading in Flap B is Blank - exit sub
If Cell below heading in Flap B has information - then copy all rows below heading in Flap B - into Flap A below last row available.
Problem - Cell below Heading in Flap A could be empty
Kindly help
Sub copy_rows()
If Sheets("Flap-B").Range("A3") = "" Then
Exit Sub
Else
' Do Something Here
Sheets("Flap-B").Select
Range("A65536").End(xlUp).Select
' Do Something Here
End If
End Sub
If Cell below heading in Flap B is Blank - exit sub
If Cell below heading in Flap B has information - then copy all rows below heading in Flap B - into Flap A below last row available.
Problem - Cell below Heading in Flap A could be empty
Kindly help
Sub copy_rows()
If Sheets("Flap-B").Range("A3") = "" Then
Exit Sub
Else
' Do Something Here
Sheets("Flap-B").Select
Range("A65536").End(xlUp).Select
' Do Something Here
End If
End Sub