fine.
Any help is appreciated.
KevinM
Sub calculate_retropay()
Dim paycode12 As Integer
Dim paycode13 As Integer
Dim paycode1E As Integer
Dim paycode1H As Integer
Dim paycode1I As Integer
Dim paycode1J As Integer
'this will search for the pay period
I want to create an email when the value in column A changes. In
column A I have the email addresses of managers. When the email
address changes I want the VBA to compose the email and get the
employees names in column B assoicated to that email address. I
don't
want it 1 for 1. I want to take
"Sheet1").Range("A:Z").Sort
> Key1:=Worksheets("Sheet1").Range("B1"), Order1:=xlDescending, Header:=xlYes
> End Sub
>
>
>
> On Fri, Mar 19, 2010 at 7:43 AM, KevinM wrote:
> > I want to create an email when the value in column A changes
gt; Key1:=Worksheets("Sheet1").Range("B1"), Order1:=xlDescending, Header:=xlYes
> End Sub
>
>
>
> On Fri, Mar 19, 2010 at 7:43 AM, KevinM wrote:
> > I want to create an email when the value in column A changes. In
> > column A I have the email ad
