Search results for query: *

Thank you! What an obvious work around. Sometimes I get so wrapped up in trying to find the straight-forward way to get something done in VBA that I get frustrated and lose my ability to adapt. Actually, the source and target are not in the same folder, and yet it still gives me a relative...

Thanks for the feedback! No I still get this relative path for the address property: "../Test area/Feedback/Input/filename.doc" But the full path is contained in the note that pops up when I move my cursor over that cell: "file:///c:\documents and settings\j5555\My Documents\Test...

My God, I can't take it. I have a column of cells with hyperlinks to different files. In my VBA code I want to get the absolute address of the hyperlink so that I can pass it to an Access table. I can find no property in the hyperlink object that allows me to see this (the address property is...

Ah. Thanks for the response! Now I can at least stop looking around for the answer. I thought for sure that I'd be able to do it because I can search for a fragmenet of text in the spreadsheet. But as you know, trying to do the same for formatting doesn't work. Thanks again!

Hi, I've never tried posting like this before because usually every question I have can easily be answered by googling. My problem is that I need to quickly scan an Excel workbook (sheet by sheet is o.k.) to detect the presence of strike-through font, non-black text, comments or shaded cells...