For Loop Problem

So I have been trying to adapt some code that a kind EF user helped me with and I seem to be having issuing with the new for loop I've created. I'm trying to get the code to multiply the last column in the array with another array one by one but I'm having two issues. It replaces every value in the last column with 24. I've attached the file; am I missing something basic in my code?

Try the attached.

Brilliant! I was just trying to work in the n = n + 1 part but kept getting an out of range. Thank you!

Quick question, what is the difference between putting the "." in front of Range and not including it?

Since you have more than 1 sheet and if you do not reference the sheet name, you get a funny result. The code assumes you are working on the active sheet( Which one is the active sheet depends on your cursor at any point during running). If you do with and end with, you need to include a dot. This way the code will know which sheet and range you are referring to when you loop through.

Thank you! I learned something new and crucial today! Thank you very much!