$$Excel-Macros$$ Re: Create range and select it
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 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 Sample 2.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Create range and select it
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, 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
$$Excel-Macros$$ Re: Create range and select it
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
