Maybe:
![]()
Range(Cells(StartRow, 1), Cells(EndRow, EndFormulaCol)).Copy Range(Cells(StartRow, 1).PasteSpecial xlPasteValues Application.CutCopyMode=False
Maybe:
![]()
Range(Cells(StartRow, 1), Cells(EndRow, EndFormulaCol)).Copy Range(Cells(StartRow, 1).PasteSpecial xlPasteValues Application.CutCopyMode=False
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks