This is my first post although I have been looking at this forum and learning from it for a long time.

I found myself in a weird situation when creating a Macro:

1- One of the things I do in my macro is to paste a formula (as a formula) in a cell of an Excel table:

*Range(columna & "2").Select*

*Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _*

*SkipBlanks:=False, Transpose:=False*

*Application.CutCopyMode = False*

**2- Once I paste it, this formula is automatically filled in all the cells of my table but it is not calculated!! The only thing that seems to work is manually enter to the first cell and press "Enter"**

I have tried setting again calculation to automatic (which is already set), and I have also tried the ".Calculate" command, but none of it works.

*Application.Calculation = xlCalculationAutomatic*--> not working

*--> not working*

Range(columna & "2").Calculate

Range(columna & "2").Calculate

*--> not working*

Range(columna & "2:" & columna & lrow).Calculate

Range(columna & "2:" & columna & lrow).Calculate

*Worksheets("XXX").UsedRange.Columns(columna).Calculate*--> not working

I please beg you to help me on this!

Thanks.

Kindest regards,

Villups.