Results 1 to 7 of 7

Thread: [RESOLVED] Skip cells containing text [Excel]

Threaded View

  1. Jun 11th, 2009, 09:04 AM #2
    Fizziii
    Fizziii is offline
    Addicted Member
    Join Date
    Jul 2008
    Location
    Colorado
    Posts
    193

    Re: Skip cells containing text [Excel]

    You could always use the below code to just run it if it is a number.

    Code:
    If Application.IsNumber(aCell.Value) = True Then
    Edit: I think you would put this after checking if it's a formula...
    Last edited by Fizziii; Jun 11th, 2009 at 09:10 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width