JohnKauffman
New Member
- Joined
- Nov 1, 2012
- Messages
- 36
Immediate Window - how to execute a function like SUM(A1:A3)? None of these work (unless I goofed):
? =sum("A1:A3")
? "=SUM(A1:A3)"
? =SUM(A1:A3)
? SUM(A1:A3)
? WorksheetFunction.Sum("A1:A3")
? sum(1,2,3)
But this one works fine:
? now()
11/1/2012 5:47:46 PM
? =sum("A1:A3")
? "=SUM(A1:A3)"
? =SUM(A1:A3)
? SUM(A1:A3)
? WorksheetFunction.Sum("A1:A3")
? sum(1,2,3)
But this one works fine:
? now()
11/1/2012 5:47:46 PM