Appending Text

[Guest]

I am opentext files, copying the current region, and now want to append this
text to the bottom of a master worksheet. I imagine I need to locate the
first empty cell beyond the current region to activate and paste.

Any hints how to do that?

Thanks much, John V

PS To all of you regular contributors: thanks for your volunteer assistance.
Just reading all the posts has helped me a lot.

 

[Tom Ogilvy]

Dim rng as Range
Set rng = worksheets("Master").Cells(rows.count,1).End(xlup)(2)

rng holds a reference to where you want to paste.

 

[Guest]

Thanks Tom. For my education, what does the (2) part do?

 

[Tom Ogilvy]

end(xlup) finds the last cell with data. (2) steps down one cell.