Macros

Hi Anthony

Thank you for your question

The short answer is no. A macro is essentially a procedure written in VBA. There is no practical limit to the size of a procedure.

However, it is better to split a problem down into a series of small tasks that need to be carried out in sequence. You then record separate macros for each task and then write a main macro that simply runs each of the smaller macros in turn

This simplifies the recording process and makes the macro easier to maintain

Regards

Stephen