![]() |
|
#6
|
||||
|
||||
|
Hi gsrikanth,
Try: Code:
Sub CombineValues()
Dim i As Long
With ActiveSheet
For i = 1 To .Cells.SpecialCells(xlCellTypeLastCell).Row
If IsNumeric(Evaluate(.Range("A" & i).Value)) And IsNumeric(Evaluate(.Range("B" & i).Value)) Then
.Range("B" & i).Value = Evaluate(.Range("A" & i).Value) + Evaluate(.Range("B" & i).Value)
Else
.Range("B" & i).Value = .Range("A" & i).Value & " " & .Range("B" & i).Value
End If
.Range("B" & i).NumberFormat = "General"
Next
End With
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Changing accounts on same PC
|
cjansley | Outlook | 1 | 07-27-2011 07:36 AM |
Changing the From field
|
jerem | Outlook | 2 | 10-29-2010 03:04 PM |
| Changing list of Value | xmadnet | Word | 0 | 09-07-2010 01:48 PM |
| Changing Word doc to .txt | cialili | Word | 1 | 08-02-2010 12:38 PM |
| changing font size without changing leading | carolns | Word | 1 | 09-14-2009 12:30 PM |