Results 1 to 6 of 6

What kind of "range" does WorksheetFunction.Max need?

Threaded View

spacely What kind of "range" does... 11-18-2012, 09:19 PM
cnodnarb Re: What kind of "range" does... 11-18-2012, 09:24 PM
Jacc Re: What kind of "range" does... 11-18-2012, 09:26 PM
AlphaFrog Re: What kind of "range" does... 11-18-2012, 09:29 PM
spacely Re: What kind of "range" does... 11-19-2012, 12:07 PM
protonLeah Re: What kind of "range" does... 11-18-2012, 09:40 PM
  1. #1
    Registered User
    Join Date
    09-23-2007
    Posts
    54

    What kind of "range" does WorksheetFunction.Max need?

    Starnge problem here (maybe my dumb error...)

    This works:
    msgbox WorksheetFunction.Max(Worksheets("data").Range("A6:A10))
    This doesn't:
    msgbox WorksheetFunction.Max(Worksheets("data").Range(Cells(startrow, B1var(i)), Cells(endrow, B1var(i))))
    I need variable columns and rows, that's why I need the 2nd style. At the beginning I Dim B1var() As Variant and then again ReDim B1var(1 To numbldsec) where numbldsec is an integer, but not sure that matters. startrow and endrow are not declared, but check out as integers.....

    Any ideas?
    Last edited by jeffreybrown; 11-18-2012 at 09:22 PM. Reason: As per Forum Rule #3, please use code tags…Thanks.

Thread Information

Users Browsing this Thread

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

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