Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BlackSeal

    how to get from row,col to cell coordinate?

    Thanks that was just it, but it is not in the default properties-list of an active cell that is wy I could find it. problem solved just int ime to start the weekend happy.
  2. BlackSeal

    how to get from row,col to cell coordinate?

    I've been the net for hours now before posting this questions. The question seems trival, but here we go: How can I get from a selected or activated cell it's coordinates in the form <characters><number> e.g. "QA23" I does not seem to be in the properties of the Cell, I know one can convert the...
  3. BlackSeal

    graphical representation of pulses

    I se what you mean, I was not looking at the graph correctly, this is what I wanted. Many thanks!
  4. BlackSeal

    graphical representation of pulses

    Hi onlyadrafter, I give it a try, and after some modifications I got a chart that looks the way that I wanted. This is how the macro works for me: Option Explicit Dim LATEST, TOTAL, MOVE_OVER, PULSE, MY_VALUE, ADD_VALUE As Variant Dim A_VALUES, B_VALUES, C_VALUES As Variant Dim...
  5. BlackSeal

    graphical representation of pulses

    Thanks, I'll give it a try, I'll let you know if it works. Many thanks for now.
  6. BlackSeal

    graphical representation of pulses

    Hi All, Could someone give me some pointer on howto represent the following graphically: 7.5 726 25.75 641 25.75 40.75 25.5 41.25 25.5 41 25.5 These are values in milliseconds and the format is alwyas the same, the first value of the list is a puls duration, and the next value is the duration...
  7. BlackSeal

    Howto to search for a string in a sheet, that came from another sheet

    Hi Morton, The piece of code you supplied, is exactly what I needed. Thank you very much, now I can proceed with my spreadsheet macro. Again thanks. Best regards, Alwyn
  8. BlackSeal

    Howto to search for a string in a sheet, that came from another sheet

    Ho Morten, I think a example would be more clear than to use words: The string I'm searching for is: PMSfu12345 Now for example if I find a cell that contains the following: pmsfu54321,PMSfu12345, PMSim34732 PMSfu98457 How can I change the color of only PMSfu12345 in the above string...
  9. BlackSeal

    Howto to search for a string in a sheet, that came from another sheet

    Hi Morten, Thanks for your advice. I was not aware of funtionality of 'conditional formatting' . It does almost what I'm searching for, as far as I can see it changes the color of the complete cell, but I would like only to change the color of the string that I'm searching for, and exactly...
  10. BlackSeal

    Howto to search for a string in a sheet, that came from another sheet

    Hi, I'm stuck writing a Excel97 macro that takes a string from sheet1 and I want to search for that string in sheet2. For every instance of that string in sheet2 I want to change the textcolor, until I have found them all in sheet2. I only want to change the text color of the string that I'm...

Part and Inventory Search

Back
Top