Hello. I'm new to VBA and I've been trying to get a macro that will copy
the row of a selected cell in one sheet (called Recipe Book), and copy
it into another sheet (called Missing Website) on the next blank row. I
found some coding someone posted online and I've been testing it but it
keeps crashing. The following is the code I found. I put an arrow (<--)
on the line where the code crashes. I can't figure out why the
Range("A65536").Select part doesn't work. Any help would be appreciated.
Thanks.

Sub PasteRow()
Application.ScreenUpdating = False
Worksheets("Recipe Book").Select
ActiveCell.EntireRow.Select
Selection.Copy
Worksheets("Missing Website").Select
Range("A65536").Select <--
ActiveSheet.Paste
Application.CutCopyMode = False
Sheets("Recipe Book").Select
ActiveCell.Select
Application.ScreenUpdating = True
End Sub

Note: on the "Range("A65536").Select" line the original code is
"Range("A65536").End(xlUp).Offset(1, 0).Select" but I omitted the code
after "Range("A65536" because it's the "Range("A65536").Select" part
that's not working.

*** Sent via Developersdex http://www.developersdex.com ***