Re: $$Excel-Macros$$ execute macro on delate

2012-11-02 Thread Paul Schreiner
John Wesley - ____________ From: pawel lupinski To: "excel-macros@googlegroups.com" Sent: Fri, November 2, 2012 10:42:22 AM Subject: Re: $$Excel-Macros$$ execute macro on delate Paul,   thanks a lot is working as I wa

Re: $$Excel-Macros$$ execute macro on delate

2012-11-02 Thread pawel lupinski
“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: pawel lupinski To

Re: $$Excel-Macros$$ execute macro on delate

2012-11-02 Thread Paul Schreiner
ou can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: pawel lupinski To: "excel-macros@goog

Re: $$Excel-Macros$$ execute macro on delate

2012-11-02 Thread pawel lupinski
Hi All,   I should attached file with it. about te file - this simple calculator for stock week cover. So input figure in columns "input" and calculate you number of weeks cover. With this file I have 2 problems to resolve:   I've made simple macro to calculate week covers (when you inset value i

RE: $$Excel-Macros$$ execute macro on delate

2012-11-02 Thread Rajan_Verma
Private Sub Worksheet_Change(ByVal Target As Range) 'Your code goes here End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: 02 November 2012 5:35 To: excel-macros@googlegro

Re: $$Excel-Macros$$ execute macro on delate

2012-11-02 Thread Paul Schreiner
I take it you mean "delete"? Are you wanting to do this for a specific sheet or all sheets in your workbook? You can use a Change "event" macro. for a single sheet, Worksheet_Change() for all sheets: Workbook_SheetChange() in these macros, simply test for the target value = "". If you want a S