Hello djoella,

If you are referring to a User Defined Function then yes there are limitations. A UDF can only use the values of other cells and return a value to the cell it is attached to. Nor can you call a macro from within the UDF to modify the worksheet using VBA code.

Sincerely,
Leith Ross