Problem with cells format
Posted by Antonio on February 19, 2001 12:53 AM
Hello. I need some help from you.
I've done a VBA program to import data from a mdb file to an Excel file. I have a column in a sheet of numbers that represent money. I need to put all the cells in the column with a money format.
I've tried something like this:
But it doesn't properly work. I think it would be better to change the format of the entire column of cells after they are loaded, but I don't know how to program it, I can't find in the vba reference the correct method or property.
Could anybody help me, please?
Thank you very much.