Alright, I have a range that I want the user to be able to change. Really, its an index of cells which my program references.
Right now I have:
And later:VB Code:
Sheets("Master").Select MaxCount = Application.CountA(Range("A50", "A500")) Range("B50").Select Set IndexRng = Range(ActiveCell, ActiveCell.Offset(MaxCount - 1, MaxCount - 1))
When I changed the range from "B50:AL88" to IndexRng in the statement directly above, I get the error "Type Mismatch (Error 13)", and I'm not sure whats wrong.VB Code:
CurVal = CurVal + Application.Index([Master!IndexRng], Cur(i), Cur(i - 1))
Thanks in advance.




Reply With Quote