Good morning,
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.
I please beg you to help me on this!
Thanks.
Kindest regards,
Villups.
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
Range(columna & "2").Calculate --> not working
Range(columna & "2:" & columna & lrow).Calculate --> not workingWorksheets("XXX").UsedRange.Columns(columna).Calculate --> not working
Range(columna & "2").Calculate --> not working
Range(columna & "2:" & columna & lrow).Calculate --> not workingWorksheets("XXX").UsedRange.Columns(columna).Calculate --> not working
I please beg you to help me on this!
Thanks.
Kindest regards,
Villups.