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

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