Thread
:
Find First empty cell at end of Column A
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Find First empty cell at end of Column A
No need to SELECT.
Range("A1").End(xldown).offset(1)=1 'whateveryouwanthere
or this one liner
range("b2:b22")copy range("a1").end(xldown).offset(1)
--
Don Guillett
SalesAid Software
"DG" wrote in message
...
I am copying a range of data from one sheet1 to the end of sheet2. Sheet1
will keep changing and I always want to append it to the bottom of sheet2.
Range("A1").End(xldown).Select will get me to the last USED cell. But how
do I go one more?
Also, I used Range(Range("A2").End(xlToRight),
Range("A2").End(xlDown)).Copy to copy the data. One I select the next
unused cell in sheet2 how do I paste?
Dan
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett