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