GS;687486 Wrote:
I am trying to set up the default format for date a column once I found
the
cell with the heading from C#
oRng = oSheet.UsedRange;
Excel.Range oR = oRng.Find("Date", omissing,
Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart,
Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false,
omissing, omissing);
I'm now atloos as to how to get column selected or apply format to a
col.
string s = oR.ToString();
i was searching tje ms sites w/o sucesss.
can someone give a hint?
thx
perhaps:
intersect(oRng,oR.entirecolumn).select
or:
intersect(oRng,oR.entirecolumn).NumberFormat = "dddd, mmmm dd, yyyy"
?
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=192142
http://www.thecodecage.com/forumz