I'd like to know how i can use a formula on a variable selection of cells with VB.
The problem is that i don't know how to create a code which reads the active selection i make from my Excel sheet, and then use a formula on this selection. When i want to change te numberformat of the selection (Selection.NumberFormat=....) it works fine on any selection of cells i make, but the SelectionFormula statement only works on the first cell of my slection (only one active cell in a selection). I just don't know enough of VB to solve this simple problem. Can you?