Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Type of column in EXCEL
Name: JanoPano Date: January 22, 2004 at 00:30:05 Pacific OS: WINDOWS CPU/Ram: celeron 850, 512MB
Comment:
Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your willingness.
Name: dtech10 Date: January 22, 2004 at 08:15:09 Pacific
Reply:
Hi Jano The best way to find out what code you require is the create a macro and look at the code produced. ie.
Goto Tools>Macro>Record New Macro. Click Ok Format your cells as normal using the Format>Cells>???? ie.Ctrl+1 When done select Tools>Macro>Stop Recording. Select Tools>Visual Basic Editor and look at the code produced.
example. This recorded the Currency macro which produced the folling code.
Summary: Hi, I have got two columns in excel table. Both columns contain names of companies in Croatia. My task is to compare those columns to see if there are duplicate entries. If I find company"x" in column...
Summary: Thanks mike, I tried that and nothing happened, that i think was for numbers. What i am looking for is like the post "compare two columns in excel" he was compairing names of companies, and i am just...
0 
