R
RichardO
Hello all:
How do I prevent a range from changing/shifting no matter what I do t
the worksheet.
I have range from column D to M, my table has data from column A to M.
After highlighting column D to M, I put the name "CINAME" in the nam
box. But this range changes to C to L when I copy a new data to th
sheet and run the macro on the sheet.
I found this formula:
=OFFSET(INDIRECT("Sheet1!$A$1"),0,0,CountA(Sheet1!$A:$A),CountA(Sheet1!$1:$1))
Would this prevent my range and the whole table from shifting if I g
to Insert/Name/Define and put the formula in the "Refers to" text box?
Will the A in this formula change to D because my range is from D to
or it doesn't matter?
Thanks.
Richard
How do I prevent a range from changing/shifting no matter what I do t
the worksheet.
I have range from column D to M, my table has data from column A to M.
After highlighting column D to M, I put the name "CINAME" in the nam
box. But this range changes to C to L when I copy a new data to th
sheet and run the macro on the sheet.
I found this formula:
=OFFSET(INDIRECT("Sheet1!$A$1"),0,0,CountA(Sheet1!$A:$A),CountA(Sheet1!$1:$1))
Would this prevent my range and the whole table from shifting if I g
to Insert/Name/Define and put the formula in the "Refers to" text box?
Will the A in this formula change to D because my range is from D to
or it doesn't matter?
Thanks.
Richard