Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate number of weeks a variable spans in | Excel Worksheet Functions | |||
Indirect a range that spans multiple sheets | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Combine data that spans two rows, preserving cells? | Excel Discussion (Misc queries) | |||
Individual record spans multiple rows | Excel Worksheet Functions |