| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a range object inside a formula
Hello, how would I go about this:
Range("F8").Activate Selection.End(xlToRight).Select ActiveCell.Offset(2, 0).Select Range("F10", Selection).Select Dim rge As Range Set rge = Selection Range("C10").FormulaR1C1 = "=sum(" & rge & ")" Thats the concept of what I want to do. How do I fix it? I want to do this since the range is not always the same. The range selection and object is good. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set Global Variable Inside Object Module | Excel Programming | |||
| Problem using an object inside another object.. | Excel Programming | |||
| range inside RANK formula based on contents of other cells | Excel Worksheet Functions | |||
| Implement object persistence inside Excel | Excel Discussion (Misc queries) | |||
| Assigning array to range inside Excel Object | Excel Programming | |||
Threaded Mode
