Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range of cells using VB
I need to copy a range of cells, but I don't know the cell I'm in.
For example, I may be cell "A6". I want to select and copy X number of cells down. Every example shows 'Range("A6:A45").Select.' What I need is something like 'Range(fromThisCell:toThisCell).Select' Can I use the Offset command somehow to select a relitive number of cells? I have two files open, and I want to copy a range of cells from one sheet to the next. The problem is the range of data will always start in row 6, but the columns will vary. Any help with this will be greatly appreciated. If I did not present my question clearly, please e-mail me and I will elaborate. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range of cells using VB
You can use Resize
Activecell.Resize(6,1) is 6 rows down from, including, the active cell. Or Ramge("A6").Resize(6,1) -- HTH RP "Stuart" wrote in message om... I need to copy a range of cells, but I don't know the cell I'm in. For example, I may be cell "A6". I want to select and copy X number of cells down. Every example shows 'Range("A6:A45").Select.' What I need is something like 'Range(fromThisCell:toThisCell).Select' Can I use the Offset command somehow to select a relitive number of cells? I have two files open, and I want to copy a range of cells from one sheet to the next. The problem is the range of data will always start in row 6, but the columns will vary. Any help with this will be greatly appreciated. If I did not present my question clearly, please e-mail me and I will elaborate. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range of cells using VB
Bob,
Thanks for the quick responce. The ActiveCell.Resize did not work; VB showed a 'compile error =expected' and I could not figure out what I was missing. But, using VB Help, I looked up the Resize function, and found that "Selection.Resize(rangeToCopy, 1).Select" would in fact do exactly what I wanted (and works!) Again, thanks for pointing me in the right direction! Stuart *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range of cells using VB
Stuart,
I just tried to show you the technique, you have to set something to that range, such as Set myRange = ActiveCell.Resize(6,1) which returns you a range object that you can work with. I tend to avoid select like the plague if I can, it is slow and usually not necessary. -- HTH RP "Stuart Sigafoos" wrote in message ... Bob, Thanks for the quick responce. The ActiveCell.Resize did not work; VB showed a 'compile error =expected' and I could not figure out what I was missing. But, using VB Help, I looked up the Resize function, and found that "Selection.Resize(rangeToCopy, 1).Select" would in fact do exactly what I wanted (and works!) Again, thanks for pointing me in the right direction! Stuart *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy certain range of cells | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Copy Range of Cells in Same Row | Excel Discussion (Misc queries) | |||
Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming |