Posts by WTF Canucks

Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank
Can't seem to get the formula to show all empty cells in the Total as ""

[TABLE="width: 249"]

[TD="colspan: 5"]PRODUCT MIX %[/TD]

PC

XP

LM

PCL

TOT (=100%)

5

10

15

70

100

40

50

20

ERROR

ERROR

[/TABLE]

Re: Ambiguous name detected: Worksheet_Change - Combining code possible solution

Hi
They are both for same sheet and thanks for combining. Strange but it worked for a while now it is no longer changing lower into upper case?

Re: Sum all cells = 100%, if sum is &lt;&gt; than 100%, Error, if all cells blank, Sum = bl

Thanks Smallman, you rock.

Hi All,
Thinking that I have to try and have these combined as I'm getting an error when calculating. Not a programmer so really could use the assistance of the User Community out there.

Compile error:
Ambiguous name detected: Worksheet_Change

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Target.Column = 2 Or Target.Column = 3 Then
    Range("B" & Target.Row) = Now()




    End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End Sub

Re: Sum all cells = 100%, if sum is &lt;&gt; than 100%, Error, if all cells blank, Sum = bl

NJIMACK,

Awesome, :lol:, made my day.

Sum all cells = 100%, if sum is &lt;&gt; than 100%, Error, if all cells blank, Sum = blank

Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank
Can't seem to get the formula to show all empty cells in the Total as ""

[TABLE="width: 249"]

[TD="colspan: 5"]PRODUCT MIX %[/TD]

PC

XP

LM

PCL

TOT (=100%)

5

10

15

70

100

40

50

20

ERROR

ERROR

[/TABLE]

Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank
Can't seem to get the formula to show all empty cells in the Total as ""

[TABLE="width: 249"]

[TD="colspan: 5"]PRODUCT MIX %[/TD]

PC

XP

LM

PCL

TOT (=100%)

5

10

15

70

100

40

50

20

ERROR

ERROR

[/TABLE]