| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why won't this work
Sub Macro1()
total = [d65000].End(xlUp).Value ActiveCell.FormulaR1C1 = "=RC[-2]*RC[-1]" ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 = "=RC[-1]/total" End Sub there are numerical values in columns A B & C, i run this macro when i am in D. -- Thank You in advance, Zab |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
why won't this work
This line:
ActiveCell.FormulaR1C1 = "=RC[-1]/total" Should be: ActiveCell.FormulaR1C1 = "=RC[-1]/" & total But unless you already have data in column D, you probably will not get the results you expect. "Zab" wrote in message ... Sub Macro1() total = [d65000].End(xlUp).Value ActiveCell.FormulaR1C1 = "=RC[-2]*RC[-1]" ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 = "=RC[-1]/total" End Sub there are numerical values in columns A B & C, i run this macro when i am in D. -- Thank You in advance, Zab |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
why won't this work
i will be able to use what you have given me
THANKS!!! zab "JLGWhiz" wrote: This line: ActiveCell.FormulaR1C1 = "=RC[-1]/total" Should be: ActiveCell.FormulaR1C1 = "=RC[-1]/" & total But unless you already have data in column D, you probably will not get the results you expect. "Zab" wrote in message ... Sub Macro1() total = [d65000].End(xlUp).Value ActiveCell.FormulaR1C1 = "=RC[-2]*RC[-1]" ActiveCell.Offset(0, 1).Select ActiveCell.FormulaR1C1 = "=RC[-1]/total" End Sub there are numerical values in columns A B & C, i run this macro when i am in D. -- Thank You in advance, Zab . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| Copy work sheet to another work book, pros and cons | Excel Programming | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
| If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
Linear Mode
