zookeepertx
Well-known Member
- Joined
- May 27, 2011
- Messages
- 591
- Office Version
- 365
- Platform
- Windows
Hello experts!
I'm having a problem with formatting on a sheet. The macro I had made for the sheet seemed to work before but then I had to add a couple of features and now I have issues, but the issues are nowhere near the part of the coding I altered.
In the image below, Z-Unit, AA-ASN and AB-Order cost are all formatted as text. This seems to be where the problem starts.
I need to insert a column after AB-Order cost, format as currency and enter a formula starting in what will now be AC to multiply Z-Unit times AB-Order Cost, then fill that formula down to the end of the data.
Then insert a column after AA-ASN, format as number and enter a formula starting in what will now be AB to multiply AA - ASN times 1 to (theoretically) make it show a number, then copy AB and paste special value back over into AA and delete AB.
The person that asked me for the macro used to copy a column from a blank sheet and insert it after AB, format as currency, put in the formula and it was fine. Then he'd copy a column from a blank sheet and insert it after AA, format as a number, put in the formula and it was fine.
However, when I try either doing it like he did - which seems like a waste of time to create a blank sheet just to copy the columns from - and do it like he used to it fails. And, if I do it like I think makes sense - insert blank columns where they're needed, format as a number or currency (whichever is called for in that column), then put in the formulas it fails. In both cases the formulas return 0.
And another weird thing is that, either way I try to do it, when the return 0, the entire column shows up with a strikethrough! When I look at the formatting for the cells, strikethrough is NOT checked!
I'm so confused and have NO idea why any of this is happening, unless Excel has completely lost its mind. Can anyone help me?
Thanks!
Jenny
I'm having a problem with formatting on a sheet. The macro I had made for the sheet seemed to work before but then I had to add a couple of features and now I have issues, but the issues are nowhere near the part of the coding I altered.
In the image below, Z-Unit, AA-ASN and AB-Order cost are all formatted as text. This seems to be where the problem starts.
I need to insert a column after AB-Order cost, format as currency and enter a formula starting in what will now be AC to multiply Z-Unit times AB-Order Cost, then fill that formula down to the end of the data.
Then insert a column after AA-ASN, format as number and enter a formula starting in what will now be AB to multiply AA - ASN times 1 to (theoretically) make it show a number, then copy AB and paste special value back over into AA and delete AB.
The person that asked me for the macro used to copy a column from a blank sheet and insert it after AB, format as currency, put in the formula and it was fine. Then he'd copy a column from a blank sheet and insert it after AA, format as a number, put in the formula and it was fine.
However, when I try either doing it like he did - which seems like a waste of time to create a blank sheet just to copy the columns from - and do it like he used to it fails. And, if I do it like I think makes sense - insert blank columns where they're needed, format as a number or currency (whichever is called for in that column), then put in the formulas it fails. In both cases the formulas return 0.
And another weird thing is that, either way I try to do it, when the return 0, the entire column shows up with a strikethrough! When I look at the formatting for the cells, strikethrough is NOT checked!
I'm so confused and have NO idea why any of this is happening, unless Excel has completely lost its mind. Can anyone help me?
Thanks!
Jenny
