Excel function in VBA

Asked Sep 08 '21 at 14:58

Active Sep 08 '21 at 14:58

Viewed 21 times

I can't seem to figure out the problem with the following formula down here. The output in my Excel file is =@SLUMP() - but I want to get a random number in cell (6,3).

My Excel is in Swedish and I don't know if this might disturb the VBA.

Sub test6()

Worksheets("Blad2").Cells(6, 3).Formula = "=SLUMP()"

End Sub

asked Sep 08 '21 at 14:58

Bella

Try `= "=Rand()"` – Warcupine Sep 08 '21 at 15:01
1

Change `.Formula` to `.FormulaLocal` or perhaps `.Formula2Local` if you don't want the `@`. – BigBen Sep 08 '21 at 15:02
@Warcupine your worked thank you! – Bella Sep 08 '21 at 15:14

Excel function in VBA

0 Answers0