Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select ranges of cells relative to location and then paste
hi again
i have an active cell i have selected. *using activeCell what i now want to do is copy whats in that cell into the next 11 cells down miss 3 copy into next 30 miss 2 copy into next 7 its a pain in the you know where.. any help gratefully received... many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select ranges of cells relative to location and then paste
ActiveCell.Offset(1,0).Range( _
"A1:A11,A15:A44,A47:A53").Value = ActiveCell.Value Note that this has nothing to do with column A. This represents positions relative to the activecell, so it is applicable anywhere on the spreadsheet where you have enough rows below the activecell. -- Regards, Tom Ogilvy "Buffyslay" wrote in message om... hi again i have an active cell i have selected. *using activeCell what i now want to do is copy whats in that cell into the next 11 cells down miss 3 copy into next 30 miss 2 copy into next 7 its a pain in the you know where.. any help gratefully received... many thank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select ranges of cells relative to location and then paste
well aren't you just the best!
i had to change ActiveCell.Offset(1,0).Range( _ "A1:A11,A15:A44,A47:A53").Value = ActiveCell.Value to ActiveCell.Offset(1,0).Range( _ "A1:A11,A15:A44,A47:A53").Value = ActiveCell.Formula but - big wows anyway. Why does this work this way then? with the 'a' i mean? __________________________________________________ ____ Willow: "I knew it! I knew it! Well, not in the sense of having the slightest idea, but I knew there was something I didn't know." http://www.buffyslay.co.uk *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
select ranges of cells relative to location and then paste
from a single reference cell
A1 is the reference cell A2 is the cell below the reference cell so treats the reference cell as if it were the upper left corner of the worksheet. -- Regards, Tom Ogilvy wrote in message ... well aren't you just the best! i had to change ActiveCell.Offset(1,0).Range( _ "A1:A11,A15:A44,A47:A53").Value = ActiveCell.Value to ActiveCell.Offset(1,0).Range( _ "A1:A11,A15:A44,A47:A53").Value = ActiveCell.Formula but - big wows anyway. Why does this work this way then? with the 'a' i mean? __________________________________________________ ____ Willow: "I knew it! I knew it! Well, not in the sense of having the slightest idea, but I knew there was something I didn't know." http://www.buffyslay.co.uk *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to autofill from relative location | Excel Worksheet Functions | |||
How to read value of a cell in a relative location | Excel Worksheet Functions | |||
how do I select, cut, and paste visible cells only | Excel Discussion (Misc queries) | |||
moving to relative location after finding data | Excel Programming | |||
Select an array of cells and paste to separate worksheet - 2nd post - 1st didn't work!! | Excel Programming |