VBA Macro question

[blickmjon]

Hey All,

I have a spreadsheet here that I need help with. You can download it here (the file name is Prices.xls): http://www.sendspace.com/file/mysnw2

I have a macro that is affecting each "Day." (i.e. Day1, Day2, Day3, etc.) Here is what it's doing:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 8 Then Exit Sub
On Error Resume Next
Select Case Target.Row
Case 6, 7, 21, 40, 44, 45, 48 '<<<< change cell to suit needs
Application.EnableEvents = False
Target.Value = Target.Value * 0.99
Case Else: Exit Sub
End Select
Application.EnableEvents = True
On Error GoTo 0
End Sub

It's taking 1% off of each determined row (6, 7, 21, 40, 44, 45, 48) except for the Ethanol cell (Target.Column = 8). Well, what I'm trying to figure out is how to make one of the Ethanol cells actually take off 1%. If you look at the spreadsheet... I want to have cell H21 to take off the 1%. That's the only one I want it to take place.

Any suggestions? Thanks in advance.

Blickmjon

 

[taigovinda]

Welcome to the board!

I didn't download your spreadsheet - not sure how many people here will. But does this minor change do what you want?

If Target.Column = 8 and target.row<>21 Then Exit Sub

Tai

 

[blickmjon]

taigovinda, it worked thanks.