Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro
I need help............
I am trying to get a macro to for the following problem: there are 4 lines of information spanning from ("A9:AG12"). Columns A through AF are properties from a test. Each row is a seperate test. Column AF is the date. If any two consecutive tests are outside the specific tolorance then the production of the material must stop unless the date("AF") is different. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro
For RowCount = 9 To 11
If Range("AF" & RowCount) = Range("AF" & (RowCount + 1)) Then For ColCount = 1 To Range("AE" & RowCount).Address If ((Cells(RowCount, ColCount) MaxTol) Or _ (Cells(RowCount, ColCount) < MinTol)) And _ ((Cells(RowCount + 1, ColCount) MaxTol) Or _ (Cells(RowCount + 1, ColCount) < MinTol)) Then MsgBox ("Data is out of Range") End If Next ColCount End If Next RowCount "Eric" wrote: I need help............ I am trying to get a macro to for the following problem: there are 4 lines of information spanning from ("A9:AG12"). Columns A through AF are properties from a test. Each row is a seperate test. Column AF is the date. If any two consecutive tests are outside the specific tolorance then the production of the material must stop unless the date("AF") is different. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |