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 the
Master sheet in cell B5 I change the day and this changes the ranges and
times on the squad sheet for that day. That is why I copy the same range
4 times (once after each day change)
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 the details of the sqyuad number selected.
> i then want to go to this range and copy it to another area of the
> workbook to paste the values only.
> I understand most of it but am stuck when I try to got to the range
> referencce to select it to copy.
> In cell P10 I have this formula P7&":"&P8 which crreates the range of
> the squad.
> I then have this line of code to go to that reference
> Range ("P10").value.select
> This is what does not work.
> I thought it could be because I actually have a formula in P10 so I tried
> copying this and pasting the value in P9 and then let my line of code refer
> to P9 but that does not help.
> Can someone please assist.
>
>
>
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 the details of the sqyuad number selected.
> i then want to go to this range and copy it to another area of the
> workbook to paste the values only.
> I understand most of it but am stuck when I try to got to the range
> referencce to select it to copy.
> In cell P10 I have this formula P7&":"&P8 which crreates the range of
> the squad.
> I then have this line of code to go to that reference
> Range ("P10").value.select
> This is what does not work.
> I thought it could be because I actually have a formula in P10 so I tried
> copying this and pasting the value in P9 and then let my line of code refer
> to P9 but that does not help.
> Can someone please assist.
>
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
