| T O P I C R E V I E W |
| JThieser |
Posted - 10/05/2011 : 04:42:45 AM
Hi,
i'm trying to change the format of a colunm to date and time.
i know one command wks.col1.format=4.....
But i would like to do it without the position of the col instead i would like to use the shortname...
something like wks.col(Time).Format=4....
But this doesn't work.
Any ideas??
Thanks alot |
| 3 L A T E S T R E P L I E S (Newest First) |
| JThieser |
Posted - 10/06/2011 : 03:36:30 AM
Thanks alot. |
| muckman |
Posted - 10/05/2011 : 1:41:23 PM
I personally use // Command |
| greg |
Posted - 10/05/2011 : 09:18:10 AM
These all work ..
// Command - using colnum function which returns a number
worksheet -f colnum(Time) 4;
// Object - using colnum again
wks.col$(colnum(Time)).format = 4;
// Range
range ra = col(Time);
ra.format = 4;
|
