This just copies the contents of Range P10 it does not copy the range which
P10 referrs to. I have not attached the whole workbook as it is huge so I
just took the relevant worksheet and the piece of code I am struggling with
and attached that. where the code refers to the "Master Sheet" on th
Just remembered to mention that when I go to the Master sheet (Not in the
attached file) I am changing the day of the competition and that changes
the ranges and times on the squad. Thant is why in the attached worksheet
I am copying the range 4 times.
On Friday, March 16, 2012 7:51:26 PM UTC+2
Thanks I have attached the file
On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote:
>
> I am using Excel 2007
> Depending on the squad number I select in a worksheet I have set up some
> formulas so I can find the reference for the first cell and last cell in
> the range with reference to th
