Search results for query: *

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.

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...

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

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...

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

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...

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

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...

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...

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...