| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a cell in the worksheet as a range in a VBA routine
"Gary''s Student" wrote: Say A1 contains the text: D2:E4 and A2 contains the text: I1 we want the macro to use the contents of these two cells to define the copy/paste Sub copy_it() Range(Range("A1").Value).Copy Range(Range("A2").Value) End Sub -- Gary''s Student - gsnu200817 "dhstein" wrote: I'm trying to copy some data from another file into my worksheet. I have the data copied into a new sheet but now I need to cut and paste from the range in the new sheet into the range in another sheet. I have a cell - e.g. K5 which I've created that has the range e.g. "A43122:D44367" - those values are created based on the data that got copied. I can also break it up to get any of those values in a cell so I could have K6 contents of 43122 for example. I need to understand how to use those cell contents in VBA to copy paste a range - I can't hard code the value 43122 - I have to get it from K6. So I'm not clear on the syntax for something like this. Specifically, what is the VBA loop or statement to copy that range to another location. Thanks for any help. Thanks Rick. That did the trick. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you name a worksheet by refering to a cell reference or range | Excel Discussion (Misc queries) | |||
| Copying cell with input range to different worksheet | Excel Worksheet Functions | |||
| adding comments to unprotected cell/range in protected worksheet | Excel Worksheet Functions | |||
| Worksheet Cell Range Name within VB Subroutine | Excel Discussion (Misc queries) | |||
| limit worksheet view to specified cell range | Setting up and Configuration of Excel | |||
Threaded Mode
