| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to non constant columns
I have the following problem
Todays Data Col A Col B Col C Col D Oranges Bananas Total Oranges & Bananas Tomorrows Data Col A Col B Col C Col D Oranges Pears Bananas Total Oranges & Bananas I use a find to see which column is holding Oranges & Bananas, this is working fine. However I want to refer to the whole of Column D as a range and fill this range with the formula. Can anyone tell me how to enter the formula in the code eg. Range("D" & ActiveCell.Row & ":D" & iRow).Formula = iCol + iCol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging across columns: I want column constant, but row increment | Excel Worksheet Functions | |||
| Referring to columns from within a macro | Excel Discussion (Misc queries) | |||
| Built-in Excel constant for maximum number of rows, for columns? | Excel Programming | |||
| referring to columns/cells using numbers | Excel Programming | |||
| Referring to a local or global variable or constant dynamically? | Excel Programming | |||
Threaded Mode
