| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code
I'm trying to divide Cell C2 by the data in the last row in Column B. Can
anyone help me with the VB coding for this? ActiveCell.FormulaR1C1 = "=RC[-1]/ " Also, after I've done the division I'm trying to write code to auto-fill from cell C2 down to the row that contains the word "Total" in column A. In other words, if the word "Total" appears in Cell A41 then I would like to have code that auto-fills cells C2:C41. The problem I'm having is the word "Total" will appear only once but in different rows within column A each day. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
| Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
| Write a code by code | Excel Discussion (Misc queries) | |||
Threaded Mode
