VBA Worksheet Change to monitor column and then hardcode row.

Hi Folks!! I have a worksheet that I have been trying to get working, but I being throw errors (for the same piece of code) and I am unsure how to resolve this.

I keep getting a "Compile Error: Wrong number of arguments or invalid property assignment". (see code).

Basically this is what I am wanting the worksheet change event to do:

As information is pasted from another sheet into "A:C", the code monitors "A", IF the cell has value, then
add code into D - I

Then exit (if all goes well ...)

Would one of you fine folks understand how to get this working?? I have to be able to set the range, and the Target, but the code keeps throwing me the errors.

Thank you ...
Humble VBA amateur

Please Login or Register  to view this content.

Hi Norie!

So, letting me make sure I am understanding correctly as I am trying hard as I can to learn the tricks of using VBA:

If I want to use the Target.Columns, then I need to declare Cell as Range? IE:

Please Login or Register  to view this content.

So I make the following changes?

Please Login or Register  to view this content.

ChangeEvent_Test.xlsx

ok ... here we go. I have done my best to explain in the workbook exactly what I am needing it to do.

The "AF" is just the beginning letter for the code. It does not come from anywhere. Though I have thought of adding it to the lookup table.

Yes. It has to have the AF for the code to work correctly. Pain in the rump, but it is the way the coding works.