Help with a macro please

[Buns1976]

Hi Everyone,

I'm running the following Macro that inserts a formula into a cell based on the population of another cell on the same sheet.
I need to edit the "Target, Range" to Sheet "Import", Cells B:B and can't get it figured out.

Any Help would be appreciated.

Thank you!

Private Sub Worksheet_Change(ByVal Target As Range)    If Not Intersect[COLOR=#ff0000](Target, Range("B:B")[/COLOR]) Is Nothing Then
        Application.EnableEvents = False
        Target.Offset(, 2).Formula = "=IFERROR(VLOOKUP(Import!B2,Import!$B:$B,1,FALSE),0)"
        Application.EnableEvents = True
    End If
End Sub

 

[Joe4]

To get this to run against the "Import" sheet, you need to place this code in the "Import" Sheet Module.

Note that Worksheet_Change event procedures only work when they are placed in the proper sheet module (and by proper, I mean the sheet that you want to apply it to).

 

[Fluff]

What are you trying to do with that formula?
because all it will do is return the value in B2 everytime.