| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro doesn't work
Could anyone can help to tell me what is wrong with the following macro? It
doesn't perform when I execute it. What I want is place the formula in one cell, then past it to rest of the cells within range. So the output of calculation changes because of cell "C15" change to "C16" and so on. Tks Range("N15").Select Range("N15").Formula = "=(C15-VLOOKUP(LEFT(A15,3),$A$2:$J$12,5)-VLOOKUP(LEFT(A15,3),$A$2:$J$12,6))/VLOOKUP(A15,$A$242:$F$352,6)*VLOOKUP(LEFT(A15,3),$ A$2:$J$12,10)+VLOOKUP(LEFT(A15,3),$A$2:$J$12,3)" Selection.Copy Range("N16").Select Range(Selection, Selection.End(xlDown)).Select ActiveSheet.Paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to sum doesn't work | Excel Discussion (Misc queries) | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| Macro don’t work | Excel Programming | |||
| Macro works Macro does not work | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
