Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
telling VB: if cells(a,b)="any number" then ...
Hi, this is easy for you, how to tell VB that if cells(a,b) is equal to any
number then bla bla bla. Also I would like to know: equal to string equal to fractional numbers (3.453) TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
telling VB: if cells(a,b)="any number" then ...
if cells(3,4).value = "XYZ" then ...
or if cells(5,1).value = 3.453 then ... Not sure what the problem is/was...? "filo666" wrote in message ... Hi, this is easy for you, how to tell VB that if cells(a,b) is equal to any number then bla bla bla. Also I would like to know: equal to string equal to fractional numbers (3.453) TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
telling VB: if cells(a,b)="any number" then ...
Check the various XL Isxxxx functions (search XL help for 'is
functions' -- w/o the quotes) and how VBA can use XL functions (search XL VBA help for 'excel functions' -- again, without the quotes). To test if a number is an integer or a real number, use either the \ operator or the mod operator. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, this is easy for you, how to tell VB that if cells(a,b) is equal to any number then bla bla bla. Also I would like to know: equal to string equal to fractional numbers (3.453) TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Need to know the number of times "fam" appears in a list of cells | Excel Discussion (Misc queries) | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |