Results 1 to 3 of 3
  1. #1
    SidCharming is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Location
    Minneapolis, MN
    Posts
    27

    Access VBA after populating Excel adjust row height not working

    Using Office 365 I get the image attached. What is wrong with my code that doesn't allow all the text to be fit in view? (Yes, word wrap is on)
    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	17.9 KB 
ID:	34947



    Code:
    Continue: 
       MyXL.ActiveSheet.Range("A1").Select
       MyXL.ActiveSheet.Rows.AutoFit
       MyXL.ActiveSheet.Columns("I").EntireColumn.Hidden = True        '-- Hide zero rating column
       MyXL.ActiveSheet.Protect
    End Sub

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Not sure...but perhaps you would be better off asking this question in an Excel forum, rather than here, since you appear to be talking about Excel VBA, rather than Access VBA, which are two different things...and almost 70 of our members have looked at this and not responded.

    Linq ;0)>
    Last edited by Missinglinq; 08-04-2018 at 01:04 PM.
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    I tested code and works for me.

    I don't use Office 365.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-24-2018, 01:15 AM
  2. Replies: 2
    Last Post: 02-28-2018, 05:04 PM
  3. Replies: 1
    Last Post: 02-27-2015, 10:56 AM
  4. Replies: 1
    Last Post: 03-02-2011, 03:08 PM
  5. Replies: 0
    Last Post: 02-27-2011, 07:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums