determine the actual vissible text
 

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.

determine the actual vissible text
 

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)

On Sun, 18 Jan 2009 18:21:45 -0000, "Sean Farrow"
wrote:

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.

determine the actual vissible text
 

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?

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
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.

determine the actual vissible text
 

Rick Rothstein;187661 Wrote:
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?

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
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.


I don't know if this has any relevance to your problem, but, I
discovered recently that the .text property of a Range has a maximum
limit to 1024 characters, while the .Value property will return up to
32K, in Excel 2003.


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51748

determine the actual vissible text
 

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.
"Leith Ross" wrote in message
...

Rick Rothstein;187661 Wrote:
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?

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
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.


I don't know if this has any relevance to your problem, but, I
discovered recently that the .text property of a Range has a maximum
limit to 1024 characters, while the .Value property will return up to
32K, in Excel 2003.


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51748