Greetings,
I am receiving an error on the line immediately below in the script further below. Not exactly sure why this is occurring, I seem to have used this structure in the past with success.
This is the beginning part of the script, no need to look over most of the variables
I am receiving an error on the line immediately below in the script further below. Not exactly sure why this is occurring, I seem to have used this structure in the past with success.
Code:
For Each ws In PA
This is the beginning part of the script, no need to look over most of the variables
Code:
Dim ws As WorksheetDim PA As Workbook
Dim TA As Workbook
Dim A As Integer
Dim B As Integer 'Prominent Point max/min range (sensitivity)
Dim C As Integer
Dim D As Integer
Dim E As Integer
Dim F As Integer
Dim G As Integer
Dim H As Integer
Dim I As Integer
Dim J As Integer
Dim K As Integer
Dim L As Integer
Dim M As Integer
Dim N As Integer
Dim AA As Range
Dim BB As Range
Dim CC As Range
Dim DD As Range
Dim R1 As Range
Dim R2 As Range
Set TA = Workbooks("COMM_TRE.xls")
Set PA = Workbooks("COMM_PA.xls")
For Each ws In PA