going to last row of data in a spreadsheet
 

I have a spreadsheet which is connected to another spreadsheet, which I
have called Historical and youv'e guessed it, it contains lots and lots
of data. I have a macro which copies the daily data and transfers it to
the historical data but I want to be able to see the last row of data
and that is where my cusor is. I have asked mates and they have come
up with various formulas but it doesn't want to work. Can anybody help
me.:)

I have a formula but I can't get it to work:(

Sheets("Historical").Select
lastrow = Cells(Rows.Count, "a").End(xlUp).Row
Range("A: & Lastrow").Select


--
North for Short
------------------------------------------------------------------------
North for Short's Profile: http://www.excelforum.com/member.php...o&userid=22695
View this thread: http://www.excelforum.com/showthread...hreadid=553154

going to last row of data in a spreadsheet
 

Hi,

Nearly, just don't wrap you variable in quotes.

Range("A:" & Lastrow).Select

Cheers
Andy

North for Short wrote:
I have a spreadsheet which is connected to another spreadsheet, which I
have called Historical and youv'e guessed it, it contains lots and lots
of data. I have a macro which copies the daily data and transfers it to
the historical data but I want to be able to see the last row of data
and that is where my cusor is. I have asked mates and they have come
up with various formulas but it doesn't want to work. Can anybody help
me.:)

I have a formula but I can't get it to work:(

Sheets("Historical").Select
lastrow = Cells(Rows.Count, "a").End(xlUp).Row
Range("A: & Lastrow").Select



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

going to last row of data in a spreadsheet
 

Andy Thanks I took out out the colon after trying your line and it works
a treat


--
North for Short
------------------------------------------------------------------------
North for Short's Profile: http://www.excelforum.com/member.php...o&userid=22695
View this thread: http://www.excelforum.com/showthread...hreadid=553154

going to last row of data in a spreadsheet
 

Oops, sorry didn't mean to leave that colon in. Glad your sorted anyway.

North for Short wrote:
Andy Thanks I took out out the colon after trying your line and it works
a treat



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info