Run Marco only if cell contains a number and is not empty

**PlankSpank** · 04-01-2016, 08:31 AM

I want a Macro to be run only if D1 contains an actual number. I understand VBA considers an empty cell to be numeric.

Any example solution code for this problem?

**YasserKhalil** · 04-01-2016, 09:06 AM

Try this

Please Login or Register  to view this content.

**PlankSpank** · 04-01-2016, 10:06 AM

That was it! Thanks!

Rep Added

**YasserKhalil** · 04-01-2016, 06:34 PM

You're welcome
Thanks for the feedback and for rep points

Run Marco only if cell contains a number and is not empty

LinkBack

Thread Tools

Rate This Thread

Display

Run Marco only if cell contains a number and is not empty

Re: Run Marco only if cell contains a number and is not empty

Re: Run Marco only if cell contains a number and is not empty

Re: Run Marco only if cell contains a number and is not empty

Thread Information

Users Browsing this Thread

Similar Threads

Count number of empty cells since last non-empty cell

marco that will sorte the lowest number in col C and then the highest number in col D

[SOLVED] If cell string does not contain a number make cell empty

[SOLVED] How to determine if a number formatted cell is empty and not 0

If cell contains number, past entire row into the next empty row on new sheet

[SOLVED] How to count a cell with a number or letter as 1 or an empty cell as 0

Formula to use number in cell to left & ignore any empty cells

Bookmarks

Bookmarks

Posting Permissions