Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help combining formatting in macro functions
Hi,
Frank helped me with the second part of my problem but I have now realised that the two formatting lines in the macro below override one another rather than work in sucession. Range("aa12").NumberFormat = _ Range("d10").NumberFormat & 0 (Sets the number format in DP in cell aa12 to d10 plus one more DP). 'Range("AA12").Select 'Selection.NumberFormat = "+#0.##0;-#0.##0" (Sets either a prefix of + for pos numbers or - for neg numbers). When I run the macro it sets the DP correctly at one extra than the DP in d10, but then goes to a general format losing the DP but with the prefixes. I need them to both work together. Is there another way to achieve this? Thanks for help in advance, Aaron. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help combining formatting in macro functions
On 17 Aug 2006 16:43:19 -0700, "Slashman"
wrote: Hi, Frank helped me with the second part of my problem but I have now realised that the two formatting lines in the macro below override one another rather than work in sucession. Range("aa12").NumberFormat = _ Range("d10").NumberFormat & 0 (Sets the number format in DP in cell aa12 to d10 plus one more DP). 'Range("AA12").Select 'Selection.NumberFormat = "+#0.##0;-#0.##0" (Sets either a prefix of + for pos numbers or - for neg numbers). When I run the macro it sets the DP correctly at one extra than the DP in d10, but then goes to a general format losing the DP but with the prefixes. I need them to both work together. If I understand the problem correctly, and this is untested, but try changing that format line to Selection.NumberFormat = "+#0.##0.0;-#0.##0.0" I notice that there's a single inverted comma in your posting for this line. Was this a typo because it suggests it's commented out. HTH Is there another way to achieve this? Thanks for help in advance, Aaron. __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help combining formatting in macro functions
Hi,
Yes I commented it out till I find a fix for it. I tried it but it doesent work. The importance of the two separate formatting actions on the cell in question is because the first action looks at a ref cell and makes the cell have one more DP. The next action does the + or - prefixing. Cheers, Aaron. Richard Buttrey wrote: On 17 Aug 2006 16:43:19 -0700, "Slashman" wrote: Hi, Frank helped me with the second part of my problem but I have now realised that the two formatting lines in the macro below override one another rather than work in sucession. Range("aa12").NumberFormat = _ Range("d10").NumberFormat & 0 (Sets the number format in DP in cell aa12 to d10 plus one more DP). 'Range("AA12").Select 'Selection.NumberFormat = "+#0.##0;-#0.##0" (Sets either a prefix of + for pos numbers or - for neg numbers). When I run the macro it sets the DP correctly at one extra than the DP in d10, but then goes to a general format losing the DP but with the prefixes. I need them to both work together. If I understand the problem correctly, and this is untested, but try changing that format line to Selection.NumberFormat = "+#0.##0.0;-#0.##0.0" I notice that there's a single inverted comma in your posting for this line. Was this a typo because it suggests it's commented out. HTH Is there another way to achieve this? Thanks for help in advance, Aaron. __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help combining formatting in macro functions
Here is another way of explaining it,
Because the number DP changes each time I use the spreadsheet, I cant just have it formatted for custom all the time for the + and - prefix, as when I run my macro to set the DP of that cell, it overrides the custom formatting for the + or -. I need both things to happen, is it possible or is there another way to simultaneously change the DP of the cell and apply the custom number format for + and - numbers? Cheers, Aaron. Slashman wrote: Hi, Yes I commented it out till I find a fix for it. I tried it but it doesent work. The importance of the two separate formatting actions on the cell in question is because the first action looks at a ref cell and makes the cell have one more DP. The next action does the + or - prefixing. Cheers, Aaron. Richard Buttrey wrote: On 17 Aug 2006 16:43:19 -0700, "Slashman" wrote: Hi, Frank helped me with the second part of my problem but I have now realised that the two formatting lines in the macro below override one another rather than work in sucession. Range("aa12").NumberFormat = _ Range("d10").NumberFormat & 0 (Sets the number format in DP in cell aa12 to d10 plus one more DP). 'Range("AA12").Select 'Selection.NumberFormat = "+#0.##0;-#0.##0" (Sets either a prefix of + for pos numbers or - for neg numbers). When I run the macro it sets the DP correctly at one extra than the DP in d10, but then goes to a general format losing the DP but with the prefixes. I need them to both work together. If I understand the problem correctly, and this is untested, but try changing that format line to Selection.NumberFormat = "+#0.##0.0;-#0.##0.0" I notice that there's a single inverted comma in your posting for this line. Was this a typo because it suggests it's commented out. HTH Is there another way to achieve this? Thanks for help in advance, Aaron. __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF OR and AND functions | Excel Worksheet Functions | |||
Macro not formatting correctly | Excel Discussion (Misc queries) | |||
Creating & Combining Macro to Functions | Excel Worksheet Functions | |||
Excel Macro Question about Conditional Formatting | New Users to Excel | |||
How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions |