D
Dan W
Hello,
I need a little help with a special vba summation code -
if its possible.
I currently use vba code to force cells to autosum within
macros and keep the formula. Such as:
Sub DoAutoSum()
Dim x As CommandBarControl
Set x = CommandBars.FindControl(ID:=226)
If Val(Application.Version) >= 10 Then _
Set x = x.Controls(1)
x.Execute
If Selection.Cells.Count = 1 Then
x.Execute 'Again to exit edit mode if only one cell
is selected
End If
End Sub
The change I want to make is when the formula shows up in
Excel. It currently shows something like this:
=SUM(I12:I19)
However for my special situation I would Like it to show
something like this:
=SUM(I18,I17,I16,I15,I14,I13,I12)
Is this possible using a similar line of vba code as above.
And a very basic question - (I just cannot remember) is
there a limit to how long this formula can be in Excel.
Thank You
I need a little help with a special vba summation code -
if its possible.
I currently use vba code to force cells to autosum within
macros and keep the formula. Such as:
Sub DoAutoSum()
Dim x As CommandBarControl
Set x = CommandBars.FindControl(ID:=226)
If Val(Application.Version) >= 10 Then _
Set x = x.Controls(1)
x.Execute
If Selection.Cells.Count = 1 Then
x.Execute 'Again to exit edit mode if only one cell
is selected
End If
End Sub
The change I want to make is when the formula shows up in
Excel. It currently shows something like this:
=SUM(I12:I19)
However for my special situation I would Like it to show
something like this:
=SUM(I18,I17,I16,I15,I14,I13,I12)
Is this possible using a similar line of vba code as above.
And a very basic question - (I just cannot remember) is
there a limit to how long this formula can be in Excel.
Thank You