VBA not Working

[Blytheee]

Hello Everyone,

I've been having some problems with a really simple VBA code, I have tried "save as" or Copying the file and renaming, once or twice, for some reason it has worked, most of the time it doesn't. I have to create 30, 35MB Workbooks and everything works fine, formulas and VBA apart form the below, any help would be great. Oh and it is in a module.

Sub recalcCells(): Selection = Selection.Value: End Sub

Thanks,

Matt

 

[JLGWhiz]

Hello Everyone,

I've been having some problems with a really simple VBA code, I have tried "save as" or Copying the file and renaming, once or twice, for some reason it has worked, most of the time it doesn't. I have to create 30, 35MB Workbooks and everything works fine, formulas and VBA apart form the below, any help would be great. Oh and it is in a module.

Sub recalcCells(): Selection = Selection.Value: End Sub

Thanks,

Matt

try

Sub recalcCells()
With Selection
    .Value = .Value
End With
End Sub

 

[Blytheee]

That's a no I'm afraid, highlights ".Value = .Value" on this one. I just cant figure this one out, such a simple macro!