Click here to Skip to main content
15,892,674 members
Home / Discussions / C#
   

C#

 
AnswerRe: code for IP detection on LAN Pin
dan!sh 9-Mar-09 23:28
professional dan!sh 9-Mar-09 23:28 
GeneralRe: code for IP detection on LAN Pin
EliottA10-Mar-09 3:16
EliottA10-Mar-09 3:16 
QuestionListView in C# Pin
mrithula89-Mar-09 22:02
mrithula89-Mar-09 22:02 
AnswerRe: ListView in C# Pin
MumbleB9-Mar-09 22:11
MumbleB9-Mar-09 22:11 
AnswerRe: ListView in C# Pin
Xmen Real 9-Mar-09 23:42
professional Xmen Real 9-Mar-09 23:42 
QuestionExcel Questions [modified] Pin
MumbleB9-Mar-09 21:43
MumbleB9-Mar-09 21:43 
AnswerRe: Excel Questions Pin
Mycroft Holmes9-Mar-09 23:44
professionalMycroft Holmes9-Mar-09 23:44 
GeneralRe: Excel Questions Pin
MumbleB10-Mar-09 0:43
MumbleB10-Mar-09 0:43 
I don't think that I was being rude. Although the pre tag was incorrectly placed it was still readable. Anyway, thanks for the help. What I have resorted to doing was instead search the sheet for value and then mark it in a different color. However, it only finds the first instance and then stops. How can I get it to search for the next instance? Below the code I have put together. A bit rough though.
Excel.Range currentFind = (Excel.Range)objSheet.Columns["S", Type.Missing];
Excel.Range firstFind = null;
currentFind = currentFind.Find("N", Type.Missing, Excel.XlFindLookIn.xlValues,
    Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext,
    true, Type.Missing);
while (currentFind != null)
{
    if (firstFind == null)
    {
        firstFind = currentFind;
    }
    else if (currentFind.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1,
        Type.Missing,
        Type.Missing) == firstFind.get_Address(Type.Missing, Type.Missing,
        Excel.XlReferenceStyle.xlA1,
        Type.Missing, Type.Missing))
    {
        break;
    }
    currentFind.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);
    currentFind = currentFind.FindNext(currentFind);
}

Any advice on the other Issue I mentioned?

Excellence is doing ordinary things extraordinarily well.

Questionexcel addin doubt Pin
abhiram_nayan9-Mar-09 21:37
abhiram_nayan9-Mar-09 21:37 
Questionhow to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 21:23
Ramin Rahimee9-Mar-09 21:23 
AnswerRe: how to delay sending mail in c# Pin
Mycroft Holmes9-Mar-09 21:27
professionalMycroft Holmes9-Mar-09 21:27 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 21:35
Ramin Rahimee9-Mar-09 21:35 
GeneralRe: how to delay sending mail in c# Pin
N a v a n e e t h9-Mar-09 21:47
N a v a n e e t h9-Mar-09 21:47 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 22:54
Ramin Rahimee9-Mar-09 22:54 
GeneralRe: how to delay sending mail in c# Pin
Christian Graus9-Mar-09 22:02
protectorChristian Graus9-Mar-09 22:02 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 22:52
Ramin Rahimee9-Mar-09 22:52 
GeneralRe: how to delay sending mail in c# Pin
Dave Kreskowiak10-Mar-09 1:29
mveDave Kreskowiak10-Mar-09 1:29 
GeneralRe: how to delay sending mail in c# Pin
Rob Philpott9-Mar-09 23:14
Rob Philpott9-Mar-09 23:14 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 23:47
Ramin Rahimee9-Mar-09 23:47 
GeneralRe: how to delay sending mail in c# Pin
Mycroft Holmes9-Mar-09 23:26
professionalMycroft Holmes9-Mar-09 23:26 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 23:42
Ramin Rahimee9-Mar-09 23:42 
QuestionA few Excel Questions Pin
MumbleB9-Mar-09 20:42
MumbleB9-Mar-09 20:42 
AnswerRe: A few Excel Questions Pin
Mycroft Holmes9-Mar-09 21:06
professionalMycroft Holmes9-Mar-09 21:06 
QuestionContextMenuStrip shortcuts problem Pin
maryam.saboor9-Mar-09 20:37
professionalmaryam.saboor9-Mar-09 20:37 
AnswerRe: ContextMenuStrip shortcuts problem Pin
Mycroft Holmes9-Mar-09 21:10
professionalMycroft Holmes9-Mar-09 21:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.