[ExcelVBA] Excel VBA date and number error

 

Hi

I'm writing a date and number in a cell, but I'm getting format errors. The date format is in Portuguese, but the VBA is writing the date in the English format.

It writes the number, but for some reason, it is written in the wrong format and the spreadsheet does not use it in calculations. If I retype the number, then it works fine.

Oddly enough, it used to be all right a couple of days ago.

I have tried applying the right formats both in the data source and target spreadsheets, but it did not work out.

The date and number format are OK in the source spreadsheet.

All be the best,

Laerte J Silva

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___