Height conflict

[elisep]

Hi!

I've got an excel file (should really be a database, but that's another issue!) that's got lots of needs. Among them, my boss would like to set a minimum row-height. We have some very long (text) cell-contents, though, and I'm finding that when I specify row height there's no way to auto-fit to show all of the longer cells. Is there a workaround?! There's no way that I could go through and manually autofit cells every time they snap back to a specified height (which seems to happen every time I run a 'sort' on the file.

HELP! (please!!)

thanks much!
e

 

[elisep]

This was working fine, but is now triggering an error to the tune of "variable not defined" refering to 'n.' Is there a way to work this?

Thanks for any assistance...

elise

 

[Andywiz]

Hmmm, not really sure about this because I can't replicate the error.

It might be that you have required the declaration of all variables in your VB Editor (also referred to as Option Explicit).

I think to resolve this, try adding a new variable declaration at the top of the macro (on a separate line). This would read:

Dim n As Integer

Please try this and let me know if you still receive the error.

Cheers,
Andy

 

[elisep]

Andy,

That seemed to do the trick. Thank you, again!

elise

(I'm going to try to make this a BeforePrint event today, as well... will take a stab solo, but might end up posting again...)