Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find next blank cell
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.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find next blank cell
Nancy
Sub findbottom() Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp) _ .Offset(1, 0).Activate End Sub Gord Dibben Excel MVP On Wed, 21 Apr 2004 20:56:13 -0700, "Nancy" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find next blank cell
Next is
Worksheets("Sheet1").Range("A1").End(xlDown).offse t(1,0) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Nancy" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the first blank row in a cell | Excel Discussion (Misc queries) | |||
macro to find the last blank cell in col. A | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
find the first and last non blank cell in a row | Excel Discussion (Misc queries) | |||
Find and blank cell then Do this..... | Excel Programming |