Author Topic: excel macro woes  (Read 341 times)

0 Members and 1 Guest are viewing this topic.

Offline Xone

  • C= 64
  • **
  • Posts: 79
  • Karma: 10
    • View Profile
excel macro woes
« on: July 04, 2017 »
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 :-\

Offline combatking0

  • JavaScript lives!
  • Senior Member
  • DBF Aficionado
  • ********
  • Posts: 4569
  • Karma: 235
  • Retroman!
    • View Profile
    • Combat King's Barcode Battler Home
Re: excel macro woes
« Reply #1 on: December 08, 2017 »
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.
You are our 9001st visitor.
Challenge Trophies Won: