Hi, I have a very large workbook that has approximately 70k lookup functions. It is quite slow - I have a macro that copies and pastes an area 30 times - this takes about 6 minutes.

Many of the cells with look up functions in them do not need to be updated everytime and so I'm wondering whethere there is a way of turning these cells 'off' as it were. Is there any command in VBA which will selectively stop some worksheets from updating and allow others to?

Having searched these forums I know there is a command for preventing all updates but I can't workout how to turn some sheet on and some off.

Many thanks