Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Build a range from a cell
I am using the OWC and i need to build a range from another range
using a starting cell. So i have src.address = "A23:AA24" dest.address = "A27" I need to calculate the end of the range based on the dest.address cell. the end result would be dest.address = "A27:AA28" I need to do this wil Excel vba... any ideas? thanks TT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Build a range from a cell
Try this:
Dim src As Range Dim dest As Range Set src = Range("A23:AA24") Set dest = Range("A27") Set dest = src.Offset(dest.Row - src.Row, dest.Column - src.Column) " wrote: I am using the OWC and i need to build a range from another range using a starting cell. So i have src.address = "A23:AA24" dest.address = "A27" I need to calculate the end of the range based on the dest.address cell. the end result would be dest.address = "A27:AA28" I need to do this wil Excel vba... any ideas? thanks TT |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Build a range from a cell
Set src = Range("A23:AA24")
Set dest = Range("A27") With src Set dest = dest.Resize(.Rows.Count, .Columns.Count) End With Debug.Print dest.Address ' $A$27:$AA$28 Before resizing you might also want to ensure the new range does would not extend off the sheet. Regards, Peter T wrote in message ps.com... I am using the OWC and i need to build a range from another range using a starting cell. So i have src.address = "A23:AA24" dest.address = "A27" I need to calculate the end of the range based on the dest.address cell. the end result would be dest.address = "A27:AA28" I need to do this wil Excel vba... any ideas? thanks TT |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Build a range from a cell
Give this a whirl...
Sub test() Dim src As Range Dim dest As Range Set src = Range("A23:AA24") Set dest = Range("A27").Resize(src.Rows.Count, src.Columns.Count) MsgBox dest.Address End Sub -- HTH... Jim Thomlinson " wrote: I am using the OWC and i need to build a range from another range using a starting cell. So i have src.address = "A23:AA24" dest.address = "A27" I need to calculate the end of the range based on the dest.address cell. the end result would be dest.address = "A27:AA28" I need to do this wil Excel vba... any ideas? thanks TT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I re - build border of my cell? | Excel Discussion (Misc queries) | |||
build a chart in a cell | Excel Discussion (Misc queries) | |||
HD I build funct @if cell=AorBorC then ...else if cell=DorE then | Excel Worksheet Functions | |||
How to build a forward/back range finder | Excel Programming | |||
How to build build a macro that automatically imports | Excel Programming |