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 |
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 |
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 |
All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com