Help combining formatting in macro functions

[Slashman]

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.

 

[Richard Buttrey]

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
__________________________

 

[Richard Buttrey]

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
__________________________

 

[Slashman]

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.

 

[Slashman]

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.

 

[Slashman]

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.