copying a row to a different tab

[rmccafferty]

I would like to copy a row in one tab (tab a) to the current cell in a different tab (tab b).

I have already run a macro that goes to tab b, goes to A200 (well below my data) and then does an End-Up arrow, and then down one row so the cursor is in column A of the highest empty row. I then assign that cell address to a variable c.

Back in Tab a I would like to use some variation of
ActiveCell.EntireRow.Copy Destination:=Range("??"). I would like to use my variable "c" to fill in the Range if possible. Would an entry like the following work?

ActiveCell.EntireRow.Copy Destination: Sheets("tab b").ActiveCell.EntireRow.Paste

 

[VoG]

Try

ActiveCell.EntireRow.Copy Destination:=Sheets("tab b").Range("A" & Rows.Count).End(xlUp).Offset(1)

 

[rmccafferty]

Thank you for the help. I am a lightweight with VBA.

As explanation, I assume the the "A" reference is just a way to say the current location?

It is not clear to me what Rows.Count does.

Of course whatever works counts, I am just always curious how and why it works.

 

[VoG]

Sheets("tab b").Range("A" & Rows.Count).End(xlUp).Offset (1)

returns the first blank row in column A.