vranjit138
Board Regular
- Joined
- Dec 18, 2006
- Messages
- 146
- Office Version
- 365
- Platform
- Windows
Hi Geeks,
I have a peculiar scenario .. i have list of values in column a and b from for rows 1 to 20 . Range from A1 to B20 shows values as 0.00 in the cells but these are actually decimal values like in cell A1 = 0.000003456 and B1 = 0.000002345. I want to write a vba code so that i can put in column C as true or false based on the values in col A and B. I need the vba code so that i can use it as a part of a logic in a module.
Please help with the vba code. I tried to declare variables as double and ran a for loop but did not get the intended result.
I have a peculiar scenario .. i have list of values in column a and b from for rows 1 to 20 . Range from A1 to B20 shows values as 0.00 in the cells but these are actually decimal values like in cell A1 = 0.000003456 and B1 = 0.000002345. I want to write a vba code so that i can put in column C as true or false based on the values in col A and B. I need the vba code so that i can use it as a part of a logic in a module.
Please help with the vba code. I tried to declare variables as double and ran a for loop but did not get the intended result.