K
Klaasv
Dear all,
I am new with the VBA part of Excel but I want to learn the language
Now I came up with the following problem. I want a pop upbox where th
user can select a range and after pressing ok this should be converte
to a formula in cell c1 (formula= "=sum(selected range)").
Now I have this:
Sub Test()
Set UserRange = Application.InputBox("Hallo", "Select your range:")
Rng = Application.WorksheetFunction.Sum(UserRange)
Range("C1").Select
Selection.Value = Rng
End Sub
After the popup it stops. Most likely because I misuse the Sum functio
but I couldn't find out a solution. Can someone help me
I am new with the VBA part of Excel but I want to learn the language
Now I came up with the following problem. I want a pop upbox where th
user can select a range and after pressing ok this should be converte
to a formula in cell c1 (formula= "=sum(selected range)").
Now I have this:
Sub Test()
Set UserRange = Application.InputBox("Hallo", "Select your range:")
Rng = Application.WorksheetFunction.Sum(UserRange)
Range("C1").Select
Selection.Value = Rng
End Sub
After the popup it stops. Most likely because I misuse the Sum functio
but I couldn't find out a solution. Can someone help me