Being Sure Of Having all cells expanded

[HLEE1167]

I need to be sure that all my cells expands and that I do not have any ##### because of a number being too big for its cell. Do you have an idea of how to do this? I had tried changing the font to Times New Roman Programatically but it do not solve the problem

Thank you

 

[HarleyQuinn]

The best way to find things like this out is to record a macro of yourself doing this then look at the code behind.

Something like this may help you:

Cells.Select
    Cells.EntireColumn.AutoFit

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HLEE1167]

Thank you for the reply. I am using similar code but I still get several cells with ###### instead of the real content. Do anyone know Why this happend and how it could be solved.

Thank you

 

[vladk]

HLEE1167,

What is your code anyway? And what data which is not shown?

vladk

 

[xlbo]

probably negative times....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[firefytr]

First of all, to address the little pet peeve of mine ...

STOP SELECTING CELLS VIA CODE!!

Sheets("Sheet1").Cells.EntireColumn.Autofit

Second, Geoff is right, because that is the ONLY other reason you'll have ###### in a cell (unless some smart a$$ has typed them in there manually - oh, don't laugh, I've seen it...).

-----------
Regards,
Zack Barresse

 

[xlbo]

LOL - just to second that - basically, any time you have 2 selectes in a row, you can get rid of both of 'em - it's kinda like quadratic equations.....(yeh - I know - that statement makes me a geek ;-) )

Cells.Select
Selection.Do_stuff

can, 99.9% of the time be replaced with

Cells.Do_Stuff

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[firefytr]

Wow, Geoff, major geek.

-----------
Regards,
Zack Barresse