Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am currently using code to create a table which includes all of the
categories found in a list and the number of times each category is found in the list. As part of this, I have the following line of code: If item = Cells(u + 1, "AR") Then This works great except in once instance where "item" or the contents of cell(u+1, "AR") may be "0". Is there a way to re-write the line so that it is not confused by a number as text? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert text string to a number code | Excel Discussion (Misc queries) | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Convert text strings to a code or number | Excel Worksheet Functions | |||
Modified VB Code for Converting Number to Text | Excel Programming | |||
Modified VB Code for Converting Number to Text | Excel Programming |