Excel 2007 : Macro intiated from a cell, The code is too large to execute, how to improve it?

[furiousfox]

Hi Guys

I'm using the following code to start a little macro that when clicking on a cell, it will populate the value in another cell.

The problem I'm facing is that I need over 1200 cells with this code (it's divided to 3 columns, 400 cells in a column)
And while creating a code for each and every cell, Excel giving me an error, saying the code is to large to execute.

Is there a way to improve the code, so I can use it on a large scale?

Here is the code:

Please Login or Register  to view this content.

This code needed for Columns N, O, P.
400 cells each. ("N1:N400") etc'

Many thanks for your help

Amit

[Richard Buttrey]

Hi,

How about just

Please Login or Register  to view this content.

Regards

[furiousfox]

Hi Richard

Thanks a million!!
Problem solved.

All the best,