| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Range.("XX").Value = (Newbie)
I have a function that sums 3 values:
******** Public Function sum(UserRange) As Double sum = 0 For Each cell In UserRange sum = sum + cell.Value Next cell Range("H5").Value = 7 : THIS DOESNT WORK ??? mysum = sum End Function ****** The call for it is in a cell (G4) , =sum(G1:G3) I am trying to set the value of another cell in this function using Range("H5").Value = 7,but it does nothing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Threaded Mode
