Excel 2007 Macros compatibilty with earlier versions!!
Are macros in Excel 2007 compatible with Excel 2003?
|
Excel 2007 Macros compatibilty with earlier versions!!
Well, as long as you don't use any XL2007-specific features then you
should be okay. So, don't use more than 256 columns or 65536 rows, don't use SUMIFS or COUNTIFS, don't use conditional formatting with more than 3 conditions, don't use xlsx/xlsm filenames, don't use full-column references in SUMPRODUCT or array formulae ... etc. It might be safer to develop the macros in XL2003 and then use them in XL2007. Hope this helps. Pete On May 8, 12:50*pm, Raja wrote: Are macros in Excel 2007 compatible with Excel 2003? |
All times are GMT +1. The time now is 04:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com