Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers and Letters
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) |