VBA for ISNUMBER function
Re: VBA for ISNUMBER function
This will test for a number as you ask for. hope gets you started, just add you code into this and shold be ok. Can delete the message box as is just a test.
Option Explicit Sub Button1_Click() ' written by: Jack in the UK ' [url]www.excel-it.com[/url] ' excel 2003 Dim rTarget As Excel.Range Dim rDestination As Excel.Range Set rTarget = Range("b13") If IsNumeric(rTarget.Value) Then ' jiuk - just a test MsgBox ("is number") 'jiuk - your code here ' if(isnumber(B13) then copy B13 (I can manage the paste). Else 'jiuk - some code here if needs be Exit Sub End If End Sub
Solved Re: VBA for ISNUMBER function
Thank you for that. I will try them in the light of day.
Garcia of Solius
Re: Solved Re: VBA for ISNUMBER function
Garcia, please use the code tags as requested when posting code. [ga]*[/ga] before posting anything further.
Don’t have an account yet? Register yourself now and be a part of our community!