Macro - Cant retrieve value from other WB

[Vihral]

Hi!

I have a Macro that is currently running like this:

.Range("B2").Formula = wb.Worksheets("3").Range("D18").Formula
.Range("B3").Formula = wb.Worksheets("3").Range("D19").Formula
.Range("B4").Formula = wb.Worksheets("3").Range("L18").Formula

This works great for the first 2 (D18 and 19) Since I manually enter those 2 values in the file when filling it out. However for the last one L18 I use this formula in the file: =SUM(M5:M16) and the result for my macro for B4 from L18 becomes 0 (it returns the formula from the other WB (=SUM(M5:M16). I tried just doing a =L18 on another cell and then use that to grab the info from but same issue happens.

What can I do so the macro can handle a formula result?


Thanks in Advance!

[ragulduy]

If I am understanding you correctly, you want the value in L18 on the other workbook, not the formula? In which case:

.Range("B4").value = wb.Worksheets("3").Range("L18").value

[Vihral]

If I am understanding you correctly, you want the value in L18 on the other workbook, not the formula? In which case:

.Range("B4").value = wb.Worksheets("3").Range("L18").value

That was a lot easier then I had through. Should always look into the simple things first. Thank you very much! Works great!