VBA Runtime Error...but I can't click on debug

I get a runtime error but I cannot click on debug. What do I do to debug this error?

"run time error 91 object variable or with block not set"

Answers


The VBAProject within the worksheet is more than likely locked. You need to unlock it. Do this by:

  • Opening up the Microsoft VBA Window ALT + F11
  • Right-clicking your VBA project
  • Selecting the VBAProject properties option
  • Clicking on the Protection tab and unselecting the Lock checkbox

Need Your Help

Optimizing foreach loop in C#, adding threads?

c# wpf multithreading math foreach

So've made a mail filtering program, it works just okey on a "test" environment. But when I wanted to try it out on a real datatbase set, waited an hour and probably could wait another 10 hours for...

Error while reading compressed CSV file from URL with pandas.read_csv

python csv pandas ipython ipython-notebook

I'm trying to use pandas.read_csv to read bz2-compressed CSV files from a URL (in this case, a GitHub raw URL) from within an IPython notebook, but I get the following error: