Calculation VB Code Issue

Good afternoon hedge

Originally Posted by hedge

i have the following code in my excel objects

It seems to be making the copy and paste features not work anymore.

Do you see a work around for this?

This code is firing everytime a different cell is selected and in doing so it clears anything copied to the clipboard. Is it really necessary to use the Selection_Change event? You'd probably be better hanging it on the Worksheet_Change event instead, thus:

Please Login or Register  to view this content.

HTH

DominicB

Hi hedge

Originally Posted by hedge

If I use that new code, when would a calculate be done?

The recalc will be done every time you add something (anything) to the worksheet, as opposed to everytime you change the selected cell.

It is unlikely that anything would change in your workbook without you doing something.

Are you saying that you have a UDF in your workbook as well? If you would like to post the code it might be possible (depending on what it does) that someone may be able to suggest a way to make it fully volatile (update when a change occurs, and not need the code I suggested).

HTH

DominicB

I would not expect the sheet to auto re calculate when you change the underlying code for a function. You would have to manually recalc.

Once the function is stable, in that you stop changing the code, then it should update when any of the cells it references change.

Other wise you will need to use the Volatile statement in the function.

You can acitvate a sheet by selecting it. If the sheet is already selected you will need to select another sheet first. But hey you already knew that as I answered your other post on exactly that topic.

I think you need to stop and think about your function and why it is that you need to keep changing it. If there are variable elements to your function perhaps those to should be information you pass to the function.

If you put the Tier and Step constants in the workbook and passed them to the function as Andy suggests, everything would recalculate automatically.

You're digging yourself into a deeper and deeper hole.