Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
how do I get data from one excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |