Excel SpellNo Not Functioning

[tariqjahangir]

Dear Excel Expert I Need Help for 1) Spellnumber Generate Iam Trying But It Is Not Functioning...Help Me And I uploaded Quotation File Aslo Following Link http://www.filedropper.com/newqt 2)And There is Next Quotation Refrence No Q4 5001 Also Error 400 But It Is Woking Kindly Help Me.....Thanks Thre is Two Problem One Is spellno and other one is Next Quotation Refrence No
Spellno Code is Attached

[davesexcel]

Your 400 error is because you are trying to clear 1/2 of a cell.The cells are merged.
The code to clear should be

   Dim rng As Range
    Set rng = Range("Q4")
    rng = rng + 1
    Range("A14:R29").ClearContents

[tariqjahangir]

Your 400 error is because you are trying to clear 1/2 of a cell.The cells are merged.
The code to clear should be

   Dim rng As Range
    Set rng = Range("Q4")
    rng = rng + 1
    Range("A14:R29").ClearContents

Sir Iam Trying But When I Click The Next Quotation No That Time In Quotation Formate All Serial No Each,Quantity,Unit Price, and Total Price,Complete Formate Is Blanked..... Againg Iam Put the formula

[davesexcel]

When I enter
=Module2.SpellNumber(P32)
I get the correct number.

[tariqjahangir]

When I enter
=Module2.SpellNumber(P32)
I get the correct number.

Thanks sir.....

[davesexcel]

Did you try changing the Column to O? instead of P or R

[tariqjahangir]

Yes Sir I Insert R Next Quotation Also Working But Problem Is When I Click The Next The Qoutation Text,Like Serial No. Unit Ea Unit Price Amount.....Ect Blank
See Screen Short 5001 i prepare the quoatation and took the print,saved again i want to make other quoataion that Time i Clik Next Quoation then 5002 All Is Blank
Quotaton uploaded following link http://www.filedropper.com/newqt_1

I Want Serial No Unit/Ea Amount (SR) Fromula as it is Quantiry unit Price No Need

[davesexcel]

??? refer to my last post, change the clearcontents range to O29

 Range("A14:O29").ClearContents

I don't like using 3rd party upload websites.

Attach a sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[tariqjahangir]

??? refer to my last post, change the clearcontents range to O29

 Range("A14:O29").ClearContents

I don't like using 3rd party upload websites.

Attach a sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Yes sir,iam trying to upload but file size is 1.26mb it is not uploading that why i uploaded 3rd party website

[davesexcel]

So was the question answered?

[tariqjahangir]

So was the question answered?

Thanks sir. i insert Range("A14:O29").ClearContents Now Ok sir it is working

[manutd275]

hi i tried spellnumber function in eglish it is ok
but i need this function in azerbaijanian language
it is very necessary can anyone help me?
1- bir
2- iki
3- üç
4- dörd
5- beş
6- altı
7- yeddi
8- səkkiz
9- doqquz
10- on
11- on bir
12- on iki
13- on üç
14- on dörd
15- on beş
16- on altı
17- on yeddi
18- on səkkiz
19- on doqquz
20 - iyirmi
30 - otuz
40- qırx
50- əlli
60- altmış
70- yetmiş
80- səksən
90- doxsan
100- yüz
1000- min
million- milyon
billion- milyard
trillion- trilyard
currency manat qəpik
dollar- manat
cent- qəpik

[Richard Buttrey]

Hi,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.