Hi bpopov007,
Sorry, I'm not clear as to what you're asking!
Let me explain what the macro is doing, it might help you answer your own question.
We are using an event macro. This means that every time something happens in excel (an event) a macro can be triggered. In this case, we are saying "every time the workbook calculates - do something".
We are narrowing this down by saying If ActiveCell.Address = "$B$2" Then - this restricts the number of times the "do something" occurs, and assumes you have B2 selected, and any changes are made ON ANOTHER SHEET.
If you want to trigger the macro when you enter something into B1, you need a different event macro. A Worksheet_Change macro - something like this.
Regards,
David
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
Bookmarks