If ISNUMERIC then copy to another location else do nothing?

Hello, kind people!

How to check is cell has number value, if it's empty or text do nothing.

Please Login or Register  to view this content.

This code every time shows that D8 is numeric although it's empty or text.
Why is this happening?

Thank you so much!

Help. So i have D7:H7 let's say "start times" and in D8:H8 "finish times" All on the same sheet(SHEET1). IF ANY OF D8:H8 IS BLANK OR IS NOT NUMBER do not copy to D7:H7, IF d8 is number then copy to d7, if e8 isn't number(or isblank) don+t copy to e7. And so on. I hope anyone is understood me. Row 7 is "start time" and I don't want to have text(or blank) as "start time". Basically, after report on "SHEET1" is printed please dear EXCELFORUM check cells in row 8 and if conditions is true copy each one of D8:H8 to the row 7. Sorry for too long bad English text!

I somehow solved it.

Please Login or Register  to view this content.