VBA Code to multiply column by value

[NatalieEC]

Hello,

I am a little stuck on why this won't work. I copied values from one sheet to another. Now, on the new sheet, I'd like to multiply one particular column by 1000. However, the multiplication is not updating.

Please Login or Register  to view this content.

[Arkadi]

Questions on this:

1. Do you know what the value of "i" is when it runs? Maybe your "For" loop is not running since i would have to be greater than 12
2. "Cells(c, B)" would not really work, since you are using B without quotes VBA would treat is as a variable, and is presumably 0 at the moment, replace your B with a 2?

[NatalieEC]

Okay, I made those corrections. For i, I set it equal to a cell. Because the first column represents the test number, I used that to represent the last row. I know this is not the most efficient way. It works now actually.

Please Login or Register  to view this content.

[Arkadi]

Hi Natalie,

Does this mean the issue is resolved? You could change your code for i as follows, to pick up the last cell:

Please Login or Register  to view this content.

[NatalieEC]

Awesome, that line worked! I guess it is resolved now. Thanks!

[Arkadi]

Please don't forget to marked as SOLVED
Glad we could help you out!