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. |
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 |