Hello all,
I would like to select a range and add a specific number of cells to it. This is what I have so far:
i want to do something like ("a3:b2+2") for a range but am unsure how to write the +2 part. Any help is greatly appretiated.
Please Login or Register to view this content.
Thanks,
dustin
Not sure what you mean,
Your code nowhere matches what you want.
Your code will select A2:B(whatever number you have in I21)Please Login or Register to view this content.
What does it have to do with
("a3:b2+2")?
sorry. the look back period is in days which in that cell. if i21 is 12 days then the range would be a3:b12. What I want to be is a3:b14. if cell i21 was 20 I would want the range to be a3:b22. I want to add 2(or any specific number) to the number part of the range.
Is this not working for you?
Please Login or Register to view this content.
Last edited by abousetta; 04-02-2012 at 10:46 PM. Reason: Should be Long instead of String
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
wow that was easy enough. i never tried putting the +2 inside the ampersand symbols, I was writing it as "a3:b" & lookbackperiod & "+2". Do you know why this doesnt work? I get "Method Range' of object '_Global' failed"
thanks for the answer.
Hi,
The reason is what the final product looks like. If you say:
this is translated intoPlease Login or Register to view this content.
See the problemPlease Login or Register to view this content.Excel is now trying to go use b10+2 as a range which in it's thinking is not the same as b12.
Hope this helps.
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks