View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Iffy Functionality Iffy Functionality is offline
external usenet poster
 
Posts: 2
Default VB Function Needed - Differentiate between a number and a characte

Hello,

Trying to setup a simple code to rearrange some data. The data looks like:

blah blah
123
33
222
123
44
22
blah blah

What I'm doing is moving all of the data into one line. The data is always
in groups of threes with text strings thrown into random rows in between the
groups of three. I have a VB script set to reorganize the data, however I
can't find a function or appropriate method to tell whether the cell that is
currently selected contains a number or character string. Can you offer any
help or ideas?

Thank you!
Iffy