I'd do something like this

if IsNumeric(Cell.value) then
....do your thing
else

end if
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Noob McKnownowt" wrote:

Hey guys just a quick question, is there any way of getting a piece of code
to tell the difference between a number and a letter, for example

if cell.value = cell.value.text (a letter or group of letters) then
copy info into col a
elseif cell.value = cell.value.number (a number or group of numbers) then
copy info into col b
end if

I am not asking for any specific code to complete a task, just if any of you
know how to get your code to distinguish between a number or letter without
stating either of them specifically.

Any assistance would be greatly apprieciated.

The Noob