Search results for query: *

Thanks to both of you! I tried them out and they worked beautifully! I ended up using the textbox idea just so I can move it around if I want, once the macro puts it there. Sorry for my post earlier after IRStuff's first post -- I saw the &d and &t for date and time, but somehow I missed the $f...

Mutt -- Thanks so much! That worked like a charm! Thanks for saving my project! --Eric

IRStuff -- thanks for your quick reply! Unfortunately, the date of the run (recorded in the actual filename) is different from the date I might be analyzing the data, so the Date and Time functions don't really work for me. The Sheet would work, except the sheets are already named with other...

I made a macro to display several charts based on a single run on a machine. The filenames of the Excel files are saved as the date of the run and the materials used (i.e. 030708N.xls would be July 8, 2003 Nitrogen. Is there any way for a macro to display the name of the file on the graph so...

I'm trying to get an Excel macro to apply a formula to an entire column. I have a machine that exports an entire column of the exact time each step was performed. To make comparisons between runs, I would rather this act as a counter. So, I created a simple formula to make a new column that...