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.
Dim LookBackPeriod As String LookBackPeriod = Range("i21").Value Range("a3:b" & LookBackPeriod & "").Select
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)Dim LookBackPeriod As String LookBackPeriod = Range("i21").Value Range("a3:b" & LookBackPeriod).Select
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?
Dim LookBackPeriod As Long LookBackPeriod = Range("i21").Value Range("a3:b" & LookBackPeriod + 2).Select
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 intoDim LookBackPeriod As Long LookBackPeriod = 10 Range("a3:b" & lookbackperiod & "+2")
See the problemRange("a3:b10+2")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