Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO can I calc just one line?
hi, trying to see if I can calculate just 1 line, if I enter data in a
specific column.. thanks. other example have to start with: (jumps cursor to different cell in same row) (J2 J3 are named ranges) If Not Intersect(Me.Range(J3), .Cells) Is Nothing Then With Me.Cells(.Row, J2) 'PERFORM OTHER TASK HERE .Offset(0, 0).Select End With End If |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO can I calc just one line?
The easiest way to have a macro recalculate a cell or a set of cells is to
have the macro re-enter or re-assert the formulas in those cells. -- Gary''s Student - gsnu200860 "MrDave" wrote: hi, trying to see if I can calculate just 1 line, if I enter data in a specific column.. thanks. other example have to start with: (jumps cursor to different cell in same row) (J2 J3 are named ranges) If Not Intersect(Me.Range(J3), .Cells) Is Nothing Then With Me.Cells(.Row, J2) 'PERFORM OTHER TASK HERE .Offset(0, 0).Select End With End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2Q:Indirect worksheet selection in macro, Calc off for specific sh | Excel Discussion (Misc queries) | |||
Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
Calc cost pro rata (nested IF's and macro to find empty row) | Excel Worksheet Functions | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
calc locks up after running a macro that moves sheets to a new fil | Excel Discussion (Misc queries) |