Coba tambahkan macro ini di VBE Sheet (Sheet1):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column >= 3 And Target.Column <= 6 Then
If Target.Row >= 5 And Target.Row <= 10 Then
Range("C14:F18").FormulaR1C1 = "=ColorFunction(RC2,R5C:R9C,TRUE)"
End If
End If
End Sub
Salam,
HK
On Monday, 28 April 2014, 22:10, "Pujiono, Setyo" <[email protected]>
wrote:
Dear Excel Guru’s
Sy coba untuk menghitung produk capacity dgn base color function dengan
menambahkan macro dan ternyata berhasil. Namun ketika sy mengganti color di
capacitynya, ternyata di perlukan satu macro unutk merefresh total
colorfunction nya. Udah coba bikin macro, cuman hasil keluar dari area diimana
cell yang di harapkan.
Option di excel untuk formula udah otomatis.
Mohon bantuan nya Gan, unutk create macro yang mana jika sy mengganti capacity
color, refresh product output qty akan terhitung .
Thanks.
Best Regards,
Setyo Pujiono
Email : [email protected]
________________________________
The information contained in this message may be confidential and legally
protected under applicable law. The message is intended solely for the
addressee(s). If you are not the intended recipient, you are hereby notified
that any use, forwarding, dissemination, or reproduction of this message is
strictly prohibited and may be unlawful. If you are not the intended recipient,
please contact the sender by return e-mail and destroy all copies of the
original message.
