Last row in another spreadsheet 1

[mpadgett]

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

 

[AnotherHiggins]

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.

 

[mpadgett]

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.

 

[Bong]

iBlnkRwNo = cells(1,1).xlDown(end).row + 1

_________________
Bob Rashkin

 

[mpadgett]

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

-MP

 

[Bong]

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

sorry

_________________
Bob Rashkin

 

[mpadgett]

Perfect! Thanks-a-lot!

-MP

 

[Bong]

Dog knows, dislexia can be a bother!

_________________
Bob Rashkin