Selecting the first unoccupied cell in a worksheet.

S

Stan Katz

In one worksheet, how do I refer to the first unoccupied
cell in a column in another worksheet?
 
P

Peo Sjoblom

Stan said:
In one worksheet, how do I refer to the first unoccupied
cell in a column in another worksheet?
Click to expand...

=CELL("address",INDEX(Sheet2!A1:A2000,MATCH(TRUE,Sheet2!A1:A2000="",0)))

entered with ctrl + shift & enter will return the address to the first
empty cell


Peo Sjoblom\
\
(No private emails please, for everyone's\
benefit keep the discussion in the newsgroup/forum)\
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An old chestnut: finding the last cell in a range 10
Unoccupied Rooms - Booking 3
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
VBA to do a mailmerge from a Specific Excel worksheet 0
An old chestnut: finding the last cell in a range 7
What to do of balance columns? 1
Embed the same Excel multiple times 0
using vba to loop an insert query until all records in query are d 4

Top