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!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- BlackSeal
- Thread
- Replies: 4
- Forum: -Engineering spreadsheets
-
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...- BlackSeal
- Thread
- Replies: 6
- Forum: -Engineering spreadsheets
-
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...- BlackSeal
- Thread
- Replies: 8
- Forum: -Engineering spreadsheets
