Prev: Renaming tabs
Next: Add-in doesn't load properly
From: JOSEPH WEBER on 12 May 2010 12:14
I want to do an if statement within a macro that will copy and paste to
another cell, a field that is text. Anything numerical should be skipped. How
do I do this?
From: JLGWhiz on 12 May 2010 13:49
Here is one way.

Set rng = Sheets("Sheet1).Range("A1")
If Not IsNumeric(rng) Then
rng.Copy Sheets("Sheet2").Range("A2")
End If


"JOSEPH WEBER" <JOSEPHWEBER(a)discussions.microsoft.com> wrote in message
news:A5D52B8A-7923-416B-9C20-3F18A7594374(a)microsoft.com...
>I want to do an if statement within a macro that will copy and paste to
> another cell, a field that is text. Anything numerical should be skipped.
> How
> do I do this?


 | 
Pages: 1
Prev: Renaming tabs
Next: Add-in doesn't load properly