Forum Discussion

1OldCoder's avatar
1OldCoder
Copper Contributor
Jun 20, 2022

Excel VBA

I am copying and pasting a sheet with imbedded formulas.  The sum formula range is being extended to include and additional cell.  Then a blue line is placed over the extended sum range that can't be removed.  No cell under the blue line can be clicked on.  They appear to be locked by excel.

Any ideas will be appreciated.

Macros and VBA

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jun 21, 2022
    Could be several (without picture or file, difficult to understand)...
    But please have a look in the "View" menu.
    You should have the wrap preview enabled there.
    Try "Normal".