Question

system.argumentoutofrangeexception cells can hold a maximum of 32 767 characters

Answer 1

At times you may require to select multiple cells in a range or different ranges in Microsoft Excel, for deleting the data or applying a format painter for font color or border......

The most common and basic way to select these adjacent cells ranges in Microsoft Excel is using mouse drag select method. We can quickly highlight the cells but only when these cells are adjacent cells or cells that are located beside each other.........