While attempting to build a dynamic activity calender I have given up o
the "basic" fomulas in Excel because it is only possible to embed up t
seven fomulas in one (i.e. I have embedded seven "If...then" formula
into one big motherf...). This big fomula is called in an "overview
calender and refers to data in another spreadsheet containing
detailed calender, and my problem is that I want to be able to proces
more than the possible 7-in-1 formula and I figure that the way to d
that is to make a loop in VBA. Is it possible to integrate a loop i
excel without making it as an "update" macro? So that when I plot dat
in the "data" spreadsheet it shows in the general calender without m
having to press update?
--
Message posted from
http://www.ExcelForum.com