Need help with Excel macro

  • Thread starter Thread starter Zapper
  • Start date Start date
Z

Zapper

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 know someone can handle this one.
 
Zapper,

The focus of this newsgroup is macros in Access, the database programme.
Macros in Access are a very different concept from macros in Excel.
You will have better luck in an Excel newsgroup.
 
Back
Top