View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default how to select a column from a cell after find

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