formula value input

[eddie1]

Newbie in troubles...


following VBA works with keyboard input only, but not if Target.Colum
= 3 contains a formula ....

HowTo ?

Thanks for your help


Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Column = 3 Then
x = Cells(Rows.Count, "d").End(xlUp).Row + 1
Range("D" & x) = Range("C" & Target.Row)
End If
End Su

 

[Frank Kabel]

Hi
if you ned to monitor the change of a formula use the
worksheet_calculate event

 

[Dave Peterson]

You didn't like the suggestions you got yesterday?

http://groups.google.com/[email protected]

If you're looking for old posts, you can use google (maybe a few hours behind)
to search for stuff you've posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm