Multiply then copy

[helpexcel]

Hi - Is there a way to use a macro to multiply .Range("P" & .Rows.Count).End(xlUp) and ws1.Range("A10") then paste the value in ws1.Range("C10")? I guess I could use .Formula, but I was also reading about PasteSpecial and xlMultiply. I just haven't been able to figure out how exactly to use it. thanks!

 

[Eric W]

Why not just:

ws1.Range("C10").Value = .Range("P" & .Rows.Count).End(xlUp).Value * ws1.Range("A10").Value

You could use PasteSpecial, but you'd need to populate C10 with one of the two values first, then copy the other value, and do a PasteSpecial over the first with the xlMultiply option.

 

[helpexcel]

THANKS! I forgot you could do that...sometimes i make this more difficult than it needs to be.