Re: $$Excel-Macros$$ IFERROR function from XL 2003 to 2007

Paul, that does the trick, thanks ! On Dec 2, 12:23 pm, Paul Schreiner wrote: > If "touching" the cell works, then simply do a find/replace > and replace iferror with iferror. > > they all should recalculate then. > > Paul -- -

$$Excel-Macros$$ IFERROR function from XL 2003 to 2007

File was created in XL2003, I had an "IFERROR(x,y)" VBA function referenced in cell formula, see: http://min.us/mvj137H Now in XL2007, I removed the VBA "IFERROR" so as to use the built-in IFERROR. The problem is as you see in the picture, XL2007 is NOT automatically using the built-in. (F9

$$Excel-Macros$$ Define a Range based on a Range object

Given a Range object (e.g: set xRange = Range("C1:D10") ) And given xRow = 5 , which stands for Row 5 (absolute Row index) How to define a range "yRange" based on "xRange" so that yRange is Range("C5:D10") ? thanks -- -

$$Excel-Macros$$ XLS 2003 to 2007 Concerns

We're finaly going to Office 2007 VBA code-wise, what issues we may have ? thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. J

$$Excel-Macros$$ Move all data to one column

I have data in multiple columns like this : http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg I'd like data moved to one single column (like column #1) Can someone help me out with a macro ? Much appreciated. Terry --~--~-~--~~~---~--~~ Visit the b