Excel 2007 New Blank Row

17/09/2008 - 11:17 von Bigpond | Report spam
Can you help please
I am writing a data base in excel for our school, to track the resources, I
need to have a macro that will take person from the Index Spread Sheet to a
Spreadsheet called "Loan Area" and then take them to the next available
(empty) row on that sheet so that they can fill in their details,
I just cant get it to take them to the first blank cell in column A

Thanks

Peter Braun
 

Lesen sie die antworten

#1 Josef Leinders
17/09/2008 - 16:35 | Warnen spam
Hi Peter,

Selection.End(xlDown).Select
should do the trick. It will take you to the last not empty cell, just move
1 cell down from there.
Manually it corresponds to pressing "end" followed by "cursor down".

Regards
Josef

"Bigpond" schrieb im Newsbeitrag
news:xW3Ak.37111$
Can you help please
I am writing a data base in excel for our school, to track the resources,
I need to have a macro that will take person from the Index Spread Sheet
to a Spreadsheet called "Loan Area" and then take them to the next
available (empty) row on that sheet so that they can fill in their
details,
I just cant get it to take them to the first blank cell in column A

Thanks

Peter Braun

Ähnliche fragen