# Column cell and row number in opposite direction.. How to set in right path

Go to click File > Options, and in the opened Excel Options dialog, click Advanced from the left pane, and scroll to the Display group, under the Default direction section, check Right-to-left. See screenshot:

# Download Excel 2016 VBA Code: Just Copy – Paste – Run (For Accountant) Part -2

Excel having large collection of functions in-built . Mostly those functions are sufficient to complete the work. Sometimes, Excel doesn’t have a pre-built function that suits a specific need, Well not to worry about it , you can create your own function called User Defined Function or custom Excel function with help of Visual Basic for Applications (VBA). You can access a User Defined Function any time just like any other Excel function.
But the main problem is you should have good knowledge of Excel VBA Programming and need so much time to writing code as desire.
This book helps you to use ready code by just copy paste and enjoy the work.
Benefits of this books :
•Create new formula in easy way instead of using long formula
•Without any technical knowledge use the new function
•Impress your boss with fast working
•Earn 10000\$ per month by making new project with help of my other book “Ready to Use 101 Powerful Excel VBA Code”

# Count of Words in a Cell by UDF

Function for counting words in a cell excluding space (ready vba code just copy , paste and run)

`Function COUNTWORDS(Text_String As String) As Integer 'User define function counts the number of words in a cell exclude space 'www.anilnahar.com`
`String_Length = Len(Text_String)`
`For Current_Character = 1 To String_Length`
```COUNTWORDS = 0
Dim String_Length As Integer
Dim Current_Character As Integer```
```If (Mid(Text_String, Current_Character, 1)) = " " Then
COUNTWORDS = COUNTWORDS + 1
End If```
```Next Current_Character
End Function```

Description

“It is one of the beautiful compensations of life that no man (or woman) can sincerely try to help another without helping him (or her)self.” — Ralph Waldo Emerson

Everyone gets a little down in the dumps sometimes. Rather than searching the internet for cat pictures or drowning your sorrows in junk, check out these motivational short stories. We have put together the best inspirational short stories, both real and fictional, to pull you from your slump, make you smile and inspire you.

When life has got you in a slump, turn to these motivational short stories. Not only is reading them like getting an internet hug for the soul, but they just may spark an idea or a change in you for the better. Read on and get ready to smile.