Automatically update an "If" formula at the start of a macro

[derryt]

Hi all,

I have this formula linked to another workbook:

Please Login or Register  to view this content.

What would I need to do to have this result automatically update at the start of a Macro I use?

Thanks,

Derry

[JapanDave]

I am not sure I follow, would the formula not update as soon as you open the book? Or is the other book closed?

[derryt]

Hi,

The other book usernameshow will be closed, the book that this macro is in will be open all the time, hence the result may well change while you are using it.

That's why I need to have it update when a macro runs.

Cheers.

[JapanDave]

What does the macro that you run do? I still can't follow what is happening. Forgive my dullness

[derryt]

Sorry, it's my fault for not explaining very well.

Essentially, I have a macro that copies a lot of information to a master workbook from within this sheet (usernameshow is the example master)

I have it set so that if the master is in use, or read only, it updates the users workbook with the name of who is in the master so they know who to contact if they need urgent access to edit it.

The problem I am having is that you have to always select the cell and hit enter to run the formula for it to update, I need to update it when the user hits the macro button.

Essentially, I need something that will say to select the cell the formula is in, hit enter, and then continue with the macro, or if there's an easier way so be it.

I hope that explains it a little better.

Thanks.

[JapanDave]

Ahh Ok, try this,

Please Login or Register  to view this content.

[derryt]

Thanks Dave, however it is throwing up an error and not accepting this:

Please Login or Register  to view this content.

between that code.

Any ideas what I should wrap it with for this to work?