Next Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to find the code which automatically finds the next available row
in excel in order to paste some data from the clipboard. Please could you
help?
 
'next available row' can be interpreted/defined in various ways. What
criteria would *you* use to determine availablity?

If it's the cell below the last filled cell in column A

dim rng as range
set rng = cells(65536,1).End(xlup).offset(1.0).entirerow
 
try
nextavailrow=cells(activecell.row,activecell.column).end(xldown).row+1
or this might be better
lastrow=cells(rows.count,activecell.column).end(xlup).row+1
 
You must log in or register to reply here.

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

Selecting rows. 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Clipboard Toolbar Missing 4
Excel Help to copy information from one row at a time to another sheet 1
copy paste to first first open row 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA to automatically cut, paste entire row based on date input and delete row 0
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1

Back
Top