Dear Brian,
Please use it
*Range ("P10").select
*Instead of
Range ("P10").value.select
Hope it will help to u other wise it would be great if you share ur
workbook.
--
Thanks & regards,
Noorain Ansari
*http://noorainansari.com/* <http://excelmacroworld.blogspot.com/>
*http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
On Fri, Mar 16, 2012 at 11:21 PM, Brian <brianfosterbl...@gmail.com> 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
>
--
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
