how to select a column from a cell after find

G

GS

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
 
P

p45cal

I am trying to set up the default format for date a column once I foun
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 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"
?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top