How do I assign the previous value to a column?

[Mangolili]

The following code assign next value to a column.
How do I assign the previou value to a column? Where do I add
a -1? Please help. Thank you.

' This Sub reads the filters from "Value" sheet and store them in            ' availableFilters array and deletes the sheet "Value"
 ReadAvailableFilters
 For i = 1 To intColCount                If filterArray(i, 1) <> "" Then 
Assign new filter value                     
'loop through the distinct value array 
                    'find where filterarray = value array 
                    'assign next value to column                     
For x = 1 To UBound(availableFilters)
 If availableFilters(x) = Replace(filterArray(i, 1), "=", "") Then                             Range(currentFiltRange)
.AutoFilter field:=i, Criteria1:=availableFilters(x + 1)                        
 End If
 Next                 
End If            
Next                                        
End With    
End With          
End Sub

 

[Scott Huish]

What does this mean exactly?

The following code assign next value to a column.
How do I assign the previou value to a column?

Could you post some samples and expected results?

 

[Mangolili]

What I mean was when I click on a button, it will go to the next VALUE of the autofilter. I wonder what I can do to go back to the previous value of the autofilter.

But my supervisor figured it out. It's okay, thank you for replying.