Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dynamic Range
I have a dynamic range which i use
Range("A3").End(xlDown).Offset(-1, 0).Select to find the last cell with data in. Then i use ActiveCell.Resize(1, 12).Select to select across to column L What i can't seem to do is select up from ActiveCell in this case A363 (this is dynamic) to L363 to A3:L3 (this range is then required to be copied) Any help would be appreciated Thanks in advance Arnie |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dynamic Range
How about
Range(ActiveCell, ActiveCell.End(xlUp)).Resize(,12) -- __________________________________ HTH Bob "Arnie" wrote in message ... I have a dynamic range which i use Range("A3").End(xlDown).Offset(-1, 0).Select to find the last cell with data in. Then i use ActiveCell.Resize(1, 12).Select to select across to column L What i can't seem to do is select up from ActiveCell in this case A363 (this is dynamic) to L363 to A3:L3 (this range is then required to be copied) Any help would be appreciated Thanks in advance Arnie |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dynamic Range
Hi Arnie
Try this: FirstCell = "L3" LastCell = Range("A3").End(xlDown).Offset(-1, 0).Address Range(FirstCell, LastCell).Copy Regards, Per "Arnie" skrev i meddelelsen ... I have a dynamic range which i use Range("A3").End(xlDown).Offset(-1, 0).Select to find the last cell with data in. Then i use ActiveCell.Resize(1, 12).Select to select across to column L What i can't seem to do is select up from ActiveCell in this case A363 (this is dynamic) to L363 to A3:L3 (this range is then required to be copied) Any help would be appreciated Thanks in advance Arnie |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dynamic Range
Thanks for that i am posting a new question if you could help
"Bob Phillips" wrote: How about Range(ActiveCell, ActiveCell.End(xlUp)).Resize(,12) -- __________________________________ HTH Bob "Arnie" wrote in message ... I have a dynamic range which i use Range("A3").End(xlDown).Offset(-1, 0).Select to find the last cell with data in. Then i use ActiveCell.Resize(1, 12).Select to select across to column L What i can't seem to do is select up from ActiveCell in this case A363 (this is dynamic) to L363 to A3:L3 (this range is then required to be copied) Any help would be appreciated Thanks in advance Arnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range | Excel Worksheet Functions | |||
Dynamic Range | Charts and Charting in Excel | |||
Dynamic Range | Excel Worksheet Functions | |||
Dynamic Range | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |