assign this code to a button
![]()
Public Sub sumcells() Dim c As Range Dim s For Each c In Selection If WorksheetFunction.IsNumber(c.Value) Then s = s + c.Value Else s = s & c.Value & " " End If Next Range("G3").Value = s Set c = Nothing End Sub
assign this code to a button
![]()
Public Sub sumcells() Dim c As Range Dim s For Each c In Selection If WorksheetFunction.IsNumber(c.Value) Then s = s + c.Value Else s = s & c.Value & " " End If Next Range("G3").Value = s Set c = Nothing End Sub
Last edited by patel45; 08-23-2012 at 02:23 PM.
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks