Search results for query: *

Maybe this will give you a hint: https://www.rondebruin.nl/mac/section8.htm

as far as i now it 's an security issue. you have to tell your emailclient (outlook express?) that you want it to open .xls files with a doubleclick. i don't have outlook express here, so i can't tell you exactly how.

Feels a bit odd, using the English language as we are both coming from the Netherlands. Anyway, concerning your problem. Does variable y have the right value? I used your code and everything seems fine in Notepad. New line starts right under the last copied line. ries

I think PH advises you to use the ISERROR function per formula so per cell. Something like =if(iserror(formula),"",formula). In other words if the formula returns an error, fill the cell with "". Hope this helps, ries

If you are not up to VBA yet then have a look at http://www.asap-utilities.com/. It's a very useful and free utility with hundreds of functions. It includes the function to convert your worksheet in capitals with just one mouseclick! Have fun, Ries

.... and if you're not so familiar with implementing code go to http://www.asap-utilities.com/ . Among 300 other functions it has also the one you are looking for, to be activated with a simple mouseclick. Have fun, Ries

Referring to your image, on the left side you see [Look in]. Same level on the right side you see [Tools]. Click on it and find the option to add the currently opened folder to the [Look in]-list. Right-click in [Look in] so you can place your most favorite on top.