how many blank cells it spans
 

Hello,

When a cell has a long content follows with empty cells, the content will
dispaly over the empty cells. How to get the length of the content or the
number of the empty cells it spans using VBScript or any other programming
languages? Or how to check if an empty/blank cell is overlaid by a previous
cell?

Any tips?

Thanks.

Gao

how many blank cells it spans
 

Gao wrote:
Hello,

When a cell has a long content follows with empty cells, the content will
dispaly over the empty cells. How to get the length of the content or the
number of the empty cells it spans using VBScript or any other programming
languages? Or how to check if an empty/blank cell is overlaid by a previous
cell?

Any tips?

Thanks.

Hi Gao,

You can check the length of character content in a cell to some degree
with =LEN(A1), but this will not necessarily provide a way to discover
if the display of A1 will run over into an empty B1, since that depends
on the choice of formatting in A1. The latter includes choice of font,
font size, and anything else added to the display format for A1.