Is it possible to display the results of an excel formula in a message box without having the result stored anywhere? For example, I have several workbooks with multiple worksheets that I need to open and check the sum of 6 cells (these do not change between books or sheets). I am having to dig through someone elses workbooks that are not organized very well and everything is hardcoded. I tried something simple like this, but it doesn't work, obviously.
Dim str as string
Msgbox "str"
str = Sum(c49,c50,c52,d53,f9,g67)
Any help with the correct syntax would be appreciated.
Dim str as string
Msgbox "str"
str = Sum(c49,c50,c52,d53,f9,g67)
Any help with the correct syntax would be appreciated.