P
Paul
2 questions.
1) When referencing to cells, if you cut and paste, it will reorder the
references to match the moved cells. Which if the cell you have moved the
data into is also Referenced then it casues a #REF error. Is there anyway
to stop Excel 2000 from reordering the formula so that is leaves the
formula pointing at the cell you want it to. (Absolute Refernces don't
work). Just not cutting and pasting will not suffice due to the large
amount of people that would not listen and just cut and paste anyway.
2) Is there anyway with VB to see if the time is less the 5am and if so to
minus 1 of the date?
Thanks for any help in advance
1) When referencing to cells, if you cut and paste, it will reorder the
references to match the moved cells. Which if the cell you have moved the
data into is also Referenced then it casues a #REF error. Is there anyway
to stop Excel 2000 from reordering the formula so that is leaves the
formula pointing at the cell you want it to. (Absolute Refernces don't
work). Just not cutting and pasting will not suffice due to the large
amount of people that would not listen and just cut and paste anyway.
2) Is there anyway with VB to see if the time is less the 5am and if so to
minus 1 of the date?
Thanks for any help in advance