View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MrDave MrDave is offline
external usenet poster
 
Posts: 34
Default 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