determine the actual vissible text

[Sean Farrow]

Hi:
I know I can get the text and the value, from he .text,and .value
properties. How though can I obtain the text that is actually visible on
screen?
Cheers
Sean.

 

[Chip Pearson]

In what circumstances does the Text property not return the text as
displayed? Can you provide and example?

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Rick Rothstein]

You will have to describe to us exactly what you mean by "the text that is
actually visible on the screen". Do you mean you want the text from *every*
cell that is in the visible part of the screen? Or do you mean you want the
text from a particular cell only if that cell is visible on the screen? What
constitutes "visible on the screen"? When it is in the current scroll area?
What if the row or column the cell is in is hidden? Or perhaps you have
something totally different in mind?

 

[Sean Farrow]

Hi:
I mean the text visible in the cell on screen.
For example is the cell is two small for all the text to fit, I need to know
and find out what text currently actually fits in the cell.
If say the text:
This is a test
was the text in a cell but the text:
this is a
wasall that was visible, I need to know that all the text doesn't fit and
tha the text this is a is visible and currently fits in the cell.
hope this helps.
Sean.