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.

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.

--
Regards,
Tom Ogilvy

"John V" wrote in message
...
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.

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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"John V" wrote in message
...
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.

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

--
Regards,
Tom Ogilvy

"John V" wrote in message
...
Thanks Tom. For my education, what does the (2) part do?

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"John V" wrote in message
...
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.