Hi All,
I'm trying to create a macro to prompt a user to (via mouse-click) select their own range of cells, them output the Standard Deviation of those cells into a cell of my choosing.
Capture.JPG
I'd like to click on Cell E3, and have it prompt me to "Select your cell Range", Calculate the Standard Deviation of cells B2:B7 (in this case), and display the value in cell E3 (that I had initially selected via mouse cursor). I realize this can be easily accomplished via manually typing in a formula, but this is a process I'll use on multiple; workbooks, many time over, and for the life of me, I cant seem to combine the multiple processes into a single code.
Bookmarks