I'm frustrated because this must be the most basic function in vba, but anyhow.. I'm trying to divide a range by a range, so for example if I have A1:A10 and B1:B10 i want to perform A1/B1, A2/B2 and so on.. I found some solutions to this when the columns are adjacent by using "for each" and "offset", but now I want to do this with one range defined in my code and on range that's been defined/named in the workbook.
Here's the code:
I want to add something that divides elementvise "rng" with a named range (Range("USD_EUR")) . I tried rng=rng.value/Range("USD_EUR"), but that won't work..
Bookmarks