+ Reply to Thread
Results 1 to 4 of 4

Autofit 3 columns

  1. 04-30-2023, 03:52 AM #1
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Autofit 3 columns

    I need to autofit columns B to D but the following code creates an error?


    Please Login or Register  to view this content.
    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 04-30-2023, 03:56 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Autofit 3 columns

    Works for me but you don't need to activate the sheet

    Please Login or Register  to view this content.
    Which line of code errors? What is the error? Does the Cash Flow sheet exist? Is the Cash Flow sheet protected?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 04-30-2023, 04:02 AM #3
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Autofit 3 columns

    Thanks for your reply.

    Sheet was protected...

    All sorted now.
    Reply With QuoteRegister To Reply
  4. 04-30-2023, 04:06 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Autofit 3 columns

    You're welcome.


    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Why won't columns autofit?
    By Curious Dude in forum Excel General
    Replies: 1
    Last Post: 04-12-2019, 10:56 AM
  2. [SOLVED] Autofit columns error
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2017, 03:02 AM
  3. [SOLVED] Can I determine the effect of autofit to .columnwidth prior to executing the autofit?
    By kadeo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2016, 10:29 AM
  4. Want Shortkey to autofit columns
    By tinfc9519 in forum Excel General
    Replies: 2
    Last Post: 11-15-2012, 08:42 AM
  5. Autofit all columns
    By cultavix in forum Excel General
    Replies: 2
    Last Post: 11-25-2008, 07:26 AM
  6. [SOLVED] Autofit some columns
    By Me in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2005, 05:06 PM
  7. autofit the excel columns
    By cindyxl in forum Excel General
    Replies: 0
    Last Post: 02-09-2005, 12:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1