james potter
New Member
- Joined
- Aug 15, 2005
- Messages
- 45
I working on a little project but can not find a solution for a small problem.
I tried but did not succeed. So could anyone assist my?
I have a table with data, for instance, from A1 to F9, this range can change in size due to data import. The last two lines start with their data in column B. I want those rows to be deleted if they have data in column B and not in column A. I know how to code to go to the last edit cell in column A and one down. But I do not know how to make the row variabel in my code. Was the code for this part?
An other project I am working is almost the same but not with the B column part. I just want to go to the last edit cell in column A and every row under that cell can be deleted. Was it the code for this part?
Thanks sofar
I tried but did not succeed. So could anyone assist my?
I have a table with data, for instance, from A1 to F9, this range can change in size due to data import. The last two lines start with their data in column B. I want those rows to be deleted if they have data in column B and not in column A. I know how to code to go to the last edit cell in column A and one down. But I do not know how to make the row variabel in my code. Was the code for this part?
An other project I am working is almost the same but not with the B column part. I just want to go to the last edit cell in column A and every row under that cell can be deleted. Was it the code for this part?
Thanks sofar