Hi,
In my macro, I am copying and pasting a value, this is the code:
If Cells(i, 7).value > 0 Then
With Cells(i, 7).Select
Selection.Copy
Cells(i, 9).Select
Selection.pastespecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Unfortunately, I can not figure out how to copy the value ONLY if it is a number (rather than the title as well).
Does this make sense? If yes, can you help?
In my macro, I am copying and pasting a value, this is the code:
If Cells(i, 7).value > 0 Then
With Cells(i, 7).Select
Selection.Copy
Cells(i, 9).Select
Selection.pastespecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Unfortunately, I can not figure out how to copy the value ONLY if it is a number (rather than the title as well).
Does this make sense? If yes, can you help?