MACRO can I calc just one line?

  • Thread starter Thread starter MrDave
  • Start date Start date
M

MrDave

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO, syntax for move to different column 1
MACRO assistance 1
Macro question, Copy-Paste 5
Tab Names Changes 11
HOW TO DO AN IF, IN A MACRO 18
Change Reference to Columns in a Macro 12
too many dates macro 2
help with EXCEL SCRIPT 16

Back
Top