Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last row in another spreadsheet 1

Status
Not open for further replies.

mpadgett

IS-IT--Management
Jun 24, 2005
57
US
I'm trying to put some data from one spreadsheet into another. I'm automatically getting the filename of the target spreadsheet and opening it with no problem. I just need some help finding that last row in the newly opened spreadsheet.

Thanks

-MP
 
Have a look at faq707-2112 or faq707-2115.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
I slightly misrepresented my intent. I actually need to ascertain the first blank row to insert data into. I have some cells at the bottom of the spreadsheet doing some summations so my data needs to go in between those rows and the header rows.
 
iBlnkRwNo = cells(1,1).xlDown(end).row + 1

_________________
Bob Rashkin
 
Thanks Bob but it appears that (end) is causing an error.

-MP
 
oops.
iBlnkRwNo = cells(1,1).[red]end(xlDown)[/red].row + 1

sorry

_________________
Bob Rashkin
 
Dog knows, dislexia can be a bother!

_________________
Bob Rashkin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top