excel macro woes

[Xone]

I need sum help guys if poss' with a macro in excel, vba.

Trying to replace however many selected cells with a given (user input) value that calculates the cells percentage, the user input being the percentage itself.
So if I select cells from A1 down to D4 and run the macro, I'd like the macro to ask me for a given percentage and when click OK it would feed the results back into their respective cells as the resulting percentages for each cell.

I thought it would be a simple process but I ended up with a 'circular reference warning' 


help

[combatking0]

I know this thread's a few months old, but if you still need help with this I'll take a look. I've done some interesting things with Excel functions.