Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help with this problem.
I have four ranges in the same worksheet. For example: rangeA (d5:d15) rangeB (d20:d33) rangeC (d40:d67) rangeD (d74:d82) I defined four names: rangeAend (d15) rangeBend (d33) rangeCend (d67) rangeDend (d82) I want to be able to invoke a macro (Ctrl+letter) from any cell within any of the four ranges. The first thing I want to do is make sure the cell is in column D and within one of the four ranges. Then I want to FILL from that cell to the end of the range the cell is in. And then move to one cell below the end of the range. I'd appreciate any and all help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying and pasting from a range | Excel Worksheet Functions | |||
Pasting Values of range to another range | Excel Programming | |||
Pasting date in a range | Excel Programming | |||
Pasting an array into a range | Excel Programming | |||
Help - Selecting and pasting into range | Excel Programming |