Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread dguillett1
on Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Eddie Sent: Friday, November 04, 2011 8:34 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ If value found in range macro I have a differing date range (G41:G68) in a number of sheets. e.g. Sheet 1 (&qu

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: Eddie To: MS EXCEL AND VBA MACROS Sent: Fri, November 4, 2011 10:55:34 AM Subject: Re: $$Excel-Macros$$ If value found in range macro I've sorted i

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Paul
   Application.ScreenUpdating = True > > End Sub > > > Paul > > - > > “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

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Eddie
Updating = True > > > End Sub > > > > Paul > > > --------- > > > “Do all the good you can, > > > By all the means you can, > > > In all the ways you can, > > > In all the places you can, >

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Eddie
e > > End Sub > > > Paul > > - > > “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 > > --

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Eddie
-- > “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 > ----------------- > > __

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Sam Mathai Chacko
ns 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: Eddie > To: MS EXCEL AND VBA MACROS > Sent: Fr

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Paul Schreiner
To all the people you can, As long as ever you can.” - John Wesley - From: Eddie To: MS EXCEL AND VBA MACROS Sent: Fri, November 4, 2011 8:29:37 AM Subject: $$Excel-Macros$$ If value found in range macro Private Sub Worksheet

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread dguillett1
EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ If value found in range macro Private Sub Worksheet_Change(ByVal Target As Range) Sheets("1").Select If Range("f41").Value = Range("g41:g68") Then ActiveWorkbook.Sheets("1").Tab.ColorIndex = 5 Else ActiveWorkboo

Re: $$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Paul Schreiner
Sent: Fri, November 4, 2011 8:29:37 AM Subject: $$Excel-Macros$$ If value found in range macro Private Sub Worksheet_Change(ByVal Target As Range) Sheets("1").Select If Range("f41").Value = Range("g41:g68") Then ActiveWorkbook.Sheets("1").Tab.ColorIndex = 5

$$Excel-Macros$$ If value found in range macro

2011-11-04 Thread Eddie
Private Sub Worksheet_Change(ByVal Target As Range) Sheets("1").Select If Range("f41").Value = Range("g41:g68") Then ActiveWorkbook.Sheets("1").Tab.ColorIndex = 5 Else ActiveWorkbook.Sheets("1").Tab.ColorIndex = 6 End If End Sub Hi, Using the above code I'm trying to colour worksheet tabs, dete