macro with varying range of cells

jillen04 · #1 (**permalink**) 01-16-09, 16:24

How do I create a macro that takes the selected range and allows me to use that range in a formula?

Here's what I want to do:
Allow the user to select a range of cells, say Q6:Q8.
Then put this formula in cell R6.... =XIRR(Q6:Q8, P6:P8)

Is it possible?
TIA,
Joanne

freeBatjko · #2 (**permalink**) 01-20-09, 15:55

I just started VBA today, but from what I know so far, I would guess
you could write it similar to this:

'The Selection has already been made by the user when the macro is run, so:

Code:

Dim i as Long, j as Long
For i=1 to Selection.rows.count Step 1
  For j=1 to Selection.columns.count Step 1
    'DoStuff like  msgbox Selection.Cells(i,j).Value
  Next j
Next i

I haven't tried it, it's just a quick shot to give an idea.

Internet Services

Web Development

Digital Marketing

Consumer Tech