find next blank cell

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

Guest

i'm taking data from different sheets and pasting them into a new sheet. i was trying to create code that will let me find the next blank area in column A so i can paste data from 1 sheet into the next empty cell. Tks for the assistance.
 
Nancy

Sub findbottom()
Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).Activate
End Sub

Gord Dibben Excel MVP
 
Next is

Worksheets("Sheet1").Range("A1").End(xlDown).offset(1,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Nancy said:
i'm taking data from different sheets and pasting them into a new sheet. i
Click to expand...
was trying to create code that will let me find the next blank area in
column A so i can paste data from 1 sheet into the next empty cell. Tks for
the assistance.
 

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

Create if partial match then copy and paste data from one cell to another 1
Eliminate blanks while copy row and transpose 11
Copy Data from Sheet 1 to Empty Cell in Sheet 2 2
Modify working code to expand the output. 5
Finding, grouping, then copy/paste to new sheet 15
Copy rows with values in sheet 1 to next empty row in sheet2 2
Find next blank cell via macro 2
copy to next blank cell in colum 2

Back
Top