G
Guest
Hi,
I have a spreadsheet with 30 records in it. I would like a macro that
enables me to delete a record and then move all the others up. The
complicated part is that I do not want it to copy any cells below the 30
records. (I have other data here)
As an example if I am in record 1 (e.g. A1) and choose to delete it, the
macro moves (copies) cells A2:A30. If I am in record 2 and choose to delete
it, the macro moves (copies) cells A3:A30.
As you can see I need to use relative addressing for one part of the
range(A3) but not the lower limit (A30). Is this possible? If so how?
thanks
Lewis Brunton
I have a spreadsheet with 30 records in it. I would like a macro that
enables me to delete a record and then move all the others up. The
complicated part is that I do not want it to copy any cells below the 30
records. (I have other data here)
As an example if I am in record 1 (e.g. A1) and choose to delete it, the
macro moves (copies) cells A2:A30. If I am in record 2 and choose to delete
it, the macro moves (copies) cells A3:A30.
As you can see I need to use relative addressing for one part of the
range(A3) but not the lower limit (A30). Is this possible? If so how?
thanks
Lewis Brunton