allowances_returning_from_usa.jpg

Allowances while returning from USA

What to bring, and what not to bring while returning from USA and other countries is the big questions in the mind and we always go on surfing to find the questions. Here I am putting the table of...

Continue reading

seasons_350.jpg

Aphelion - Perihelion

The word "perihelion" stems from the Ancient Greek words "peri", meaning "near", and "helios", meaning "the Sun". "Aphelion" derives from...

Continue reading

chanakya.jpg

Chanakaya - 10 Points

chanakya.jpg, Oct 2016 1. There are three gems upon this earth; food, water, and pleasing words -- fools (mudhas) consider pieces of rocks as gems. 2. He who loses his money is forsaken by his...

Continue reading

Basic Principle of Landscape by Gail Hansen (University of Florida)

In Landscaping the elements of composition are the visual qualities that people see and respond to when viewing a space. Visual qualities can illicit many different emotions and feelings, and the...

Continue reading

Boilerplate or Bootstrap by Ivaylo Gerchev

Boilerplate or Bootstrap? Author: Ivaylo Gerchev https://www.sitepoint.com/boilerplate-bootstrap/ The right choice depends on two things. First, you must know your goals, needs and project’s...

Continue reading

Master Direction - Liberalised Remittance Scheme (LRS)

How Much Dollar or Foriegn Fund Can we Invest in other Countries ? Well government through 'Liberalised Remittance Scheme' has given directions how much dollar you can invest in foriegn currency. That...

Continue reading

Setting a reference to the VBA Extensibility library

When your coding the VBE you have to set a reference to the VBA Extensibility library. This can be done manualy, but also with the following code. Sub MakeLibrary()      On Error Resume Next...

Continue reading

Using Shift + F4 key to find Next Occurrence - Excel

Objective: Using Shift + F4 Key to find next occurance How is the Question ?   Step 1. Use the Find option from the Edit menu as normal, specifying what you want to search for and then looking for the...

Continue reading

Adding description to the User Defined Functions - Excel VBA

One of the new features in Excel 2010 is the ability to provide argument descriptions for user-defined functions. These descriptions appear in Function Arguments dialog box -- which is displayed after...

Continue reading

VBA Code - Select Start and Search Text in Text Box

  VBA CODE FOR Select Start in Text Box: You need a 'Form' with 'Two Textbox' Private Sub Form_Load ()    Text1.Text = "Two of the peak human experiences"    Text1.Text = Text1.Text &...

Continue reading

Precision as Displayed - VERY IMPORTANT

Precision as Displayed: Checking this box will force Excel to calculate to the number of decimal places that appear as a result of your formatting, and will permanently change any numbers stored in...

Continue reading

Controlling Excel Calculations

Look at  these options Tools -->Options-->Calculation tab. Calculation Settings Keep Changing Because a number of Excel's calculation settings work at the application level (they are the same...

Continue reading

Populating ListBox in VBA - Excel

List Populating for multi-column: ListCount starts at 1 when counting ListBox items or List. But ListBox Indexing of those items or List starts at 0. In your example, you are trying to add an item or...

Continue reading

Multiple Conditions to Calculate Total - Count using Array Formula (Simpler Version)

Create a total based on multiple conditions: Use the following formula to calculate the total value of cells F5:F25, where B5:B25 contains "Northwind" and the range C5:C25 contains the...

Continue reading

Enter or Edit the same data on Multiple Worksheets

When you select a group of sheets, changes you make to a selection on the active sheet are reflected in the corresponding cells on all other selected sheets. Data on the other sheets may be replaced....

Continue reading

Conditional Sum with More then two Conditions Posted by Aladin Akyurek from Mrexcel.com

COUNT (or COUNTA) is used for counting, SUM for summing when no condition involved. COUNTIF is used for counting, SUMIF for summing when a single condition involved. SUMPRODUCT or an array formula is...

Continue reading

Comparing Two Strings - Using VBA strcomp() Function

Comparing two strings for equality can be tricky. The result of var1 = var2 where Var1 and var2 only differ in the use of capitals depends on the Option Compare Setting. This is risky business indeed....

Continue reading

Confucius (September 28, 551 – 479 BC) a Chinese teacher, editor, politician, and philosopher.

Confucius's principles had a basis in common Chinese tradition and belief. He championed strong family loyalty, ancestor veneration, and respect of elders by their children and of husbands by their...

Continue reading

Going To Buy a Property From Developer or Builder? Check These Out First

Things to Check Before Buying A property From Developer: Builder should have a previous track record Ask how many million sq.ft he has already constructed and how many projects are underway Check out...

Continue reading

22.PNG

AutoCAD About Offsetting Objects

Command: Using Offset Command Objective: Creates a geometric object that is parallel or concentric to the selected object at a specified distance. For example, if you offset a circle or an arc, a...

Continue reading