Progress2007
06-05-2008, 01:57 AM
hello
I have a problem. I have a excel sheet in which there are diffrent Rows. i have to select data for each user and paste into another sheet and then delete it.
Now my problem is that suppose there are 200 resords for first user.
LastRow = ActiveCell.Row returns 200 for first user, now the problem is that when i insert data for second user , then also it return 200.
Will u guys pls help me ...how i will able to delete the data of sheet and refresh it so that i get the desired last row.
I have a problem. I have a excel sheet in which there are diffrent Rows. i have to select data for each user and paste into another sheet and then delete it.
Now my problem is that suppose there are 200 resords for first user.
LastRow = ActiveCell.Row returns 200 for first user, now the problem is that when i insert data for second user , then also it return 200.
Will u guys pls help me ...how i will able to delete the data of sheet and refresh it so that i get the desired last row.