Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANGE in VBA
I tried to use VBA to copy a range of data then paste it into anothe worksheet. The problem is that I create the target (to be copied) rang in INSERT---NAME---DEFINE, or a dynamic range. How can I use VBA t possibly select the dynamic range? Thanks a lot, Jasons :rolleyes -- Jason ----------------------------------------------------------------------- Jasons's Profile: http://www.excelforum.com/member.php...fo&userid=1610 View this thread: http://www.excelforum.com/showthread.php?threadid=31379 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANGE in VBA
worksheets("sheet2").Range("A1:A10").Name = "MyName"
application.Goto Range("MyName"), True might be what you want. however, if I wanted to copy something I would do Worksheets("Sheet1").Range("J11:J20").copy _ Destination:=Range("MyName") Without doing any selecting. -- Regards, Tom Ogilvy "Jasons" wrote in message ... I tried to use VBA to copy a range of data then paste it into another worksheet. The problem is that I create the target (to be copied) range in INSERT---NAME---DEFINE, or a dynamic range. How can I use VBA to possibly select the dynamic range? Thanks a lot, Jasons -- Jasons ------------------------------------------------------------------------ Jasons's Profile: http://www.excelforum.com/member.php...o&userid=16108 View this thread: http://www.excelforum.com/showthread...hreadid=313797 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANGE in VBA
Application.Goto Reference:="rangename"
Selection.copy go.to.the.other.sheet Selection.pastespecial xlall -----Original Message----- I tried to use VBA to copy a range of data then paste it into another worksheet. The problem is that I create the target (to be copied) range in INSERT---NAME---DEFINE, or a dynamic range. How can I use VBA to possibly select the dynamic range? Thanks a lot, Jasons -- Jasons ---------------------------------------------------------- -------------- Jasons's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=16108 View this thread: http://www.excelforum.com/showthread...hreadid=313797 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |