Set variable to be value of column G when any cell in row changes

[MattVoz]

Hello. I am trying to set a variable based on the value of the cell in column G of the row that is changed. For example, if I change cell A 5 I would want the value in G 5 to become the variable. If I change the value in AZ 5 I would still want the value in G 5 to become the variable. Whatever row I make the change in, I want the value in column G of that row to be the variable.

I hope that all made sense.

Thanks

Matt

[Marc L]

As a beginner starter to paste to the worksheet module :

Private Sub Worksheet_Change(ByVal Target As Range) 
    V = Cells(Target.Row, 7).Value 
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[MattVoz]

Thanks for your help, but I am getting a Compile Error: Variable not defined. It is highlighting the word 'Target'.

[Marc L]

No issue on my end so just read & apply the post #2 direction …

[MattVoz]

Perhaps the problem is because I have other code. Below is the total code I am trying to use. The variable name I am trying to set is 'filter'. I appreciate all your help.

Please Login or Register  to view this content.