Hi I am using an excel file running a vba macro. The macro code works fine on my windows pc but it doesn't work on my Mac although I have enable all macros from excel preferences.
Anyone could help??
Thank you
Anyone could help??
Thank you
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA macro doesn't work on my Mac
- Thread starter damav78
- Start date
Dear @MARK858,
The code in sheet2 actually "locks" (removes the formula) the value of cells in columns R and T when "Fixed" in cell of column B is selected. If "Fixed" is removed then the formula in those cells re appears and regenerate. The formula on those cells (R and T) is based on the values of cells D1,D2,D3.
Value of cell D1 is based on sheet1 and change continuously.
Now I am trying to resolve a problem that appeared after I use my file.
Until now cell D1 was actually a copy of the value of cell O32 of sheet1. But the percentage result I got was not right for what I want to do. So in order to resolve my issue I had to create a new formula, where at the calculations (to get the O32 percentage right) should abstract the quantities of cells at column A of sheet2 that are "Fixed".
So I made some testings to create that formula. (rows 34,35 of sheet1) and I actually finalize it in cell D1 of sheet2.
All seamed to work ok until I noticed that when I add a big amount in cell A of sheet2 and try to select "Fixed" then it gives me ###### at cell R and 0,0000 in cell T. If I don't select "Fixed" the amounts are right... but when I select it all goes down. If I expand the ###### cell the value is totally wrong.
In smaller quantities everything seems to work ok.
Also I have enabled iterative calculations for all this to work because I faced an issue when I created (I don't remember what was it...)
The code in sheet2 actually "locks" (removes the formula) the value of cells in columns R and T when "Fixed" in cell of column B is selected. If "Fixed" is removed then the formula in those cells re appears and regenerate. The formula on those cells (R and T) is based on the values of cells D1,D2,D3.
Value of cell D1 is based on sheet1 and change continuously.
Now I am trying to resolve a problem that appeared after I use my file.
Until now cell D1 was actually a copy of the value of cell O32 of sheet1. But the percentage result I got was not right for what I want to do. So in order to resolve my issue I had to create a new formula, where at the calculations (to get the O32 percentage right) should abstract the quantities of cells at column A of sheet2 that are "Fixed".
So I made some testings to create that formula. (rows 34,35 of sheet1) and I actually finalize it in cell D1 of sheet2.
All seamed to work ok until I noticed that when I add a big amount in cell A of sheet2 and try to select "Fixed" then it gives me ###### at cell R and 0,0000 in cell T. If I don't select "Fixed" the amounts are right... but when I select it all goes down. If I expand the ###### cell the value is totally wrong.
In smaller quantities everything seems to work ok.
Also I have enabled iterative calculations for all this to work because I faced an issue when I created (I don't remember what was it...)
Last edited:
Upvote
0
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 17,069
- Office Version
- 365
- Platform
- Windows
- Mobile
When Fixed is selected then column R has the formula
and D1 has the formula
Column 15 is the header of column R
and so the formula in R is referring to D2 and D2 is referring to column R...... a circular reference
Rich (BB code):
=ROUND((A9*$D$1),0)
Rich (BB code):
=IFERROR((Sheet1!M32-SUMIFS(Κλεισίματα[Column15],Κλεισίματα[Fixation],"Fixed"))/(SUMIFS(Sheet1!L2:L31,Sheet1!M2:M31,">0")-SUMIFS(Κλεισίματα[Kg],Κλεισίματα[Fixation],"Fixed")),0)and so the formula in R is referring to D2 and D2 is referring to column R...... a circular reference
Upvote
0
No… the opposite. When “Fixed” is selected on cell B the formula of cell at column R is replaced by the value that had before select “Fixed”
I lost you in the second part of your answer.
But how it comes when the value in cell A is for example 50000 not giving any error? If you try to change the value of cell A to smaller one you will see that it works ok.
Upvote
0
