PC Review


Reply
Thread Tools Rate Thread

Autosizing a Cell

 
 
halper@lgblp.com
Guest
Posts: n/a
 
      24th Oct 2006
I have three cells that contain names and are populated with a vlookup
formula. Some of the names are larger than the cells current size. Is
there a way, in either Excel or VBA, to autosize the cell this way I
can add that code to my macro before it prints to ensure the whole name
is being shown for each person.

Thanks,
Scott

 
Reply With Quote
 
 
 
 
RB Smissaert
Guest
Posts: n/a
 
      24th Oct 2006
How about:

Range("A1:A3").Columns.AutoFit

RBS

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have three cells that contain names and are populated with a vlookup
> formula. Some of the names are larger than the cells current size. Is
> there a way, in either Excel or VBA, to autosize the cell this way I
> can add that code to my macro before it prints to ensure the whole name
> is being shown for each person.
>
> Thanks,
> Scott
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autosizing textbox Tirrell Cotton Microsoft ASP .NET 2 9th Apr 2008 09:28 PM
Autosizing by macro Diego Arbe Microsoft Powerpoint 0 29th May 2007 09:27 PM
Text box autosizing =?Utf-8?B?ZmlvbmE=?= Microsoft Excel Misc 2 29th Sep 2004 01:17 AM
autosizing chris Microsoft Frontpage 1 8th Sep 2004 04:39 AM
AutoSizing TextBox Price Microsoft Excel Programming 1 12th Nov 2003 04:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:54 PM.