+ Reply to Thread
Results 1 to 4 of 4

Offset of Application.Max

  1. #1
    Registered User
    Join Date
    01-26-2011
    Location
    calif
    MS-Off Ver
    Excel 2010
    Posts
    23

    Offset of Application.Max

    I am trying to populate a userform with numbers bigger than ten and smaller than zero.
    I got help with the code below that populates labels 44 to 63 with those numbers (from column "S").
    But I am also trying to populate labels 2 to 21 with an offset of those numbers bigger than ten and smaller than zero from column "B"
    and
    labels 23 to 42 with an offset from column D.


    I have been stuck trying to figure out how to offset Application.Max. The closest thing I got to working was
    Please Login or Register  to view this content.
    but it only works with numbers.

    Thanks for your help.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Offset of Application.Max

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-26-2011
    Location
    calif
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Offset of Application.Max

    Thanks for the quick response. The code works great. The only thing is that it skips the first row of the userform. When I change line
    Please Login or Register  to view this content.
    to zero it fills the first line of the userform. Does this effect its functionality?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Offset of Application.Max

    NO it does not. You can actually delete that line since the variable is automatically initialized to zero when it is declared.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hiding Application or a Worksheet takes away the ability to use Application properties
    By tfurnivall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-01-2016, 05:44 PM
  2. [SOLVED] VBA code to change the application.username and application.userinitials
    By jwlamb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:25 PM
  3. [SOLVED] Obscure VBA error? Application.Run conflicts with Application.GetOpenFileName
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-15-2013, 08:31 PM
  4. function similar to offset to offset the offset
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 03:07 PM
  5. [SOLVED] [SOLVED] Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen)
    By Paul Martin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2005, 12:05 PM
  6. Replace application.RTD property by Application.RTDServers collect
    By John.Greenan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2005, 10:05 AM
  7. error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error
    By -[::::Shamran::::]- in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2005, 10:05 AM

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