I have a Command Button in WorkSheet1 and associated VB codes.
WorkSheet2 contains data stored from time to time.
I want to add data from worksheet1 to worksheet2.
The code when executed to find the first empty row
in WorkSheet2, does not work.
Rows in WorkSheet1, in which the Command Button
is located is being searched for the empty row.
How can I manage this?