Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to clean up an excel macro where I was referencing cells directly ("LoopCount = Range("E4").Value") instead of using named cells ("LoopCount = Cell_LoopCount").

  • So I named cell E4 "Cell_LoopCount". Its label is right there in the upper left corner whenever I select cell E4.
  • At the beginning of the macro, I added "Sheets("Data").Select" to make sure I'm operating on the right worksheet,
  • But breaking after "LoopCount = Cell_LoopCount" reveals Cell_LoopCount is empty and LoopCount = 0
  • "LoopCount = Range("E4").Value" still works fine

What obvious thing am I missing?

share|improve this question
up vote 4 down vote accepted

LoopCount = Range("Cell_LoopCount").Value

share|improve this answer
OK, I'm checking into the Serious Bonehead Treatment Center as soon as they have an opening. Thanks. – Fred Hamilton Feb 25 '10 at 0:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.