Results 1 to 13 of 13

VBA Code for Wrapping Text for Multiple Results and Preventing a Sheet from Scrolling

Threaded View

RXcel VBA Code for Wrapping Text... 10-08-2017, 05:00 AM
kev_ Re: VBA Code for Wrapping... 10-08-2017, 05:33 AM
RXcel Re: VBA Code for Wrapping... 10-08-2017, 09:38 PM
kev_ Re: VBA Code for Wrapping... 10-08-2017, 05:54 AM
RXcel Re: VBA Code for Wrapping... 10-08-2017, 10:27 PM
kev_ Re: VBA Code for Wrapping... 10-09-2017, 01:03 AM
kev_ Re: VBA Code for Wrapping... 10-09-2017, 02:41 AM
RXcel Re: VBA Code for Wrapping... 10-11-2017, 02:36 AM
kev_ Re: VBA Code for Wrapping... 10-11-2017, 05:55 AM
RXcel Re: VBA Code for Wrapping... 10-12-2017, 11:09 PM
Macpic Re: VBA Code for Wrapping... 10-13-2017, 07:18 AM
kev_ Re: VBA Code for Wrapping... 10-13-2017, 08:07 AM
Macpic Re: VBA Code for Wrapping... 10-13-2017, 08:14 AM
  1. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: VBA Code for Wrapping Text for Multiple Results and Preventing a Sheet from Scrolling

    Can you explain the Me in "Me.Range("A1:M31")"? Thank you
    VBA interprets "Me" differently depending on where the code is placed - the module determines how VBA decides

    Above, the code is in sheet module of sheet "Finder". So:
    Me = Sheets("Finder")

    Or another example - with UserForm with name "uf_Expenses"
    If the code is in the UserForm module:
    Me = UserForm named "uf_Expenses"

    Etc
    Last edited by kev_; 10-09-2017 at 04:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA: Wrapping text and transversing text between nubers or given speific text
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-08-2015, 07:52 PM
  2. Preventing ComboBox' list to detach when scrolling
    By AstroZelda in forum Excel General
    Replies: 3
    Last Post: 06-01-2015, 04:42 AM
  3. Replies: 4
    Last Post: 01-20-2014, 10:52 AM
  4. Vba code help pulling data from one sheet and generate results to another sheet
    By OATMAS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 11:45 AM
  5. Dear Users, please send me the code for scrolling text in status bar.
    By RAKESH MESHRAM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 04:00 PM
  6. Replies: 1
    Last Post: 11-14-2007, 03:41 PM
  7. Preventing Info From Scrolling ... Possible ??
    By Mhz in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-13-2006, 06:50 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1