Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a table that is supposed to show the change in another (parallel) table after changing inputs in a simulation model. Can you figure what 's wrong with the code below? Sub Macro3() Dim c As Range For Each c In Range("P44:Z54").Cells c.Formula = "=" & c.Offset(0, -14).Address(0, 0) & "-" & c.Offset(0, -14).Value Next c End Sub Thank you very much for your remarks !! Herman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
building a formula | Excel Programming | |||
VBA formula building | Excel Programming | |||
Building a zip code database | Excel Programming | |||
building code for an individual report | Excel Programming | |||
When building formula in excel, it would be very useful to have t. | Excel Programming |