what's wrong with my code??

[cc.caroline15]

Hello everyone I'm new to macros
I'm trying to create a macro that will:
getsinput from the user the location of the cell where the sum should appear. eg. user enters F6, macro will display the sum of cells B6:E6 in F6 and finish with the active cell being F6. Here is a snip of my code that I'm trying but it doesn't display the result. Can anyone help me? Thank you

 

[JHB]

I think you've more luck with your question in an Excel-forum, this one is for MS-Access!