Identify if Cell Contents Fit

[idbr]

Hi,

I'm trying to find out how to check if a cell is large enough to completely display its contents. If it's not I need to autofit the row, otherwise just set the row height to 18.

Can anyone help?

Thanks, Iain

 

[PHV]

Why not simply AutoFit ALL the rows ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[idbr]

Hi PHV,

I'm listing out some jobs (in 10pt Arial) that need to be completed. For readability, I want to keep some space around the text so am resizing all rows to 18. Autofitting everything sets the height to 12.75.

Also for readability I want the whole row to display on screen at once. Each row has a simple description of the task to be completed and the majority of these are samll enough to fit into the assigned width. Some of them aren't though, typically %-(

Thanks, Iain

 

[idbr]

Ah, just realised - do it backwards:

rows.autofit

for i = 2 to n

if rowheight = 12.75 then

rowheight = 18

else

next n


Job done