$$Excel-Macros$$ Calculate Difference between two dates

2011-01-26 Thread Jitendra Verma
Hi, How do we calculate the difference between two dates in Hours. Dates are like mm/dd/ format only. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important

$$Excel-Macros$$ Count Number of Records in worksheet

2011-01-26 Thread Jitendra Verma
Hi,, Please tell me how to count the number of total records in a worksheet using the macro or count of non blank cells in a worksheet. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 --

$$Excel-Macros$$ Problem in Data Validation in Excel

2011-01-04 Thread Jitendra Verma
Hi All, I have a question related to data validation in excel. Below is the description.. I want to create two dropdown list using the data validation list. one is for countries and other is for State of the countries. My question is if i select country from first dropdown thee second dropdown p