SOLVED - "ActiveCell" now doesn't work

I created a "Button" on the spreadsheet, and wrote a routine to be followed opn clicking the button. This was so that I could easily test the routine. Once it worked as I wanted, I deleted that Button, and instead created a Button on the "Add-in" Tab of the command bar; obviously, calling that same routine.

This routine starts by testing that the cursor is in Column A, and then tests that various related cells have certain information. If that is correct, the routine then carries out some calculations, inserts some lines and inserts various formula into various cells.

It did all work just FINE - until I changed the entry from a Button on the Sheet to one on the Command Bar

But the very first line fails !
---------------------------------
Public Sub AddDim()

Dim myCell As Range

myCell = ActiveCell
---------------------------------
Run time error 91
Object variable or With block variable not set.
--------------------------------------

I would have thought

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

You're welcome.


You use Set for an object. I don't know why it worked before.




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.