Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi again,
I tried writing a function using a "rng" and "cella" Range variable in it. My plan is to walking through cells in this range, or only in one single column of rng and calculate with cell's value. The code sample should be something like this: Function proba(ByVal cella, rng As Range) As Integer Dim item, rng1 As Range Set rng1 = rng.Columns(1) For Each item In rng1 proba = item.Value + cella.Value Next item End Function And this code doesn't work. I think my solution in reference to range "rng1" or cell is wrong, but I don't have idea. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using RANGE object in multiple-area range | Excel Programming | |||
returning pivottable object from a range object | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |