Need help with Excel macro

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.
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting in a range 12
Need Help with a VBA subroutine 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Run macro on selected sheets 10
Need help with formulas 1
Needs help combining functions. 3
Array to Multiple Arrays 3
Clear Check Box 2

Top