Recent content by rseiler

lbass, Thank you very much for the help.... I wasnt sure how to type the carrage return. This work excellent, and was exactly what I was looking for. Rick

Thanks MSBrady... I will give this a try. Rick

I'm trying to write a function that will replace all 'hard carriage returns' with ' '. I am using the Replace function, but not sure what to put in the second parameter. Replace (Procedure,"x" ," " ); Anyone have any ideas for me? Rick

Does anyone know a way to use the value of a cell to determine which cell to use in a formula. Example: =SUM(CX:C25) Where X is the value of a cell. I tried to do something like =SUM((C(value(B1)):C25) but that didn't work, any ideas out there??? Thanks!!!!

Desiree, This didn't work for me. THANK YOU SO MUCH FOR TRYING!! Not sure if this will matter but i am running Win NT with Office 97. I did however figure out how to allow the main file with all the hyperlinks to stay open. All I had to do was right click any hyperlink and choose "edit...

flareman, It has it's own name. I should have mentioned this earlier, but sometimes the file will stay open (not very often). To me, it is random. I created all the hyperlinks the same way. It doesn't seem to matter which hyperlink I click on, they all will close the main file. Thanks for...

I am having a little problem using hyperlinks in Excel. What I am trying to do is create an Excel file with about 15 hyperlinks linked to various other (read only) Excel files. This spreadsheet is to act like a shortcut screen with a description as to what is being selecting. The problem I...