Hello,
I need to paste 4 different sets of data into 1 sheet
(each set immediately following the other), and I don't
want to specifically refer to the cells to paste the
different sets into because the number of rows of data in
a set could change. I thought I would paste the first set
in, then find the last used cell in Column A, paste the
second set, find the last used cell in Column A, and so
on. My problem is I know how to find the last used cell,
but there is a formula copied down in the last column
(Col. AB). I really need to find the last used cell in
Column A, not in the entire sheet. Any help would be
greatly appreciated. Also, I'm not real slick with code,
so the more specific the better. Thanks! (Excel 2000)

Hi
for column A:

--
Regards
Frank Kabel
Frankfurt, Germany


Eva Shanley wrote:
Hello,
I need to paste 4 different sets of data into 1 sheet
(each set immediately following the other), and I don't
want to specifically refer to the cells to paste the
different sets into because the number of rows of data in
a set could change. I thought I would paste the first set
in, then find the last used cell in Column A, paste the
second set, find the last used cell in Column A, and so
on. My problem is I know how to find the last used cell,
but there is a formula copied down in the last column
(Col. AB). I really need to find the last used cell in
Column A, not in the entire sheet. Any help would be
greatly appreciated. Also, I'm not real slick with code,
so the more specific the better. Thanks! (Excel 2000)

Hi
for column A:
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

--
Regards
Frank Kabel
Frankfurt, Germany


Eva Shanley wrote:
Hello,
I need to paste 4 different sets of data into 1 sheet
(each set immediately following the other), and I don't
want to specifically refer to the cells to paste the
different sets into because the number of rows of data in
a set could change. I thought I would paste the first set
in, then find the last used cell in Column A, paste the
second set, find the last used cell in Column A, and so
on. My problem is I know how to find the last used cell,
but there is a formula copied down in the last column
(Col. AB). I really need to find the last used cell in
Column A, not in the entire sheet. Any help would be
greatly appreciated. Also, I'm not real slick with code,
so the more specific the better. Thanks! (Excel 2000)