LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default What is the VBA function to return the greater of two integers?

I'm still a VBA newbie, and I have two questions:

1. As an Object Pascal programmer, it never ceases to amaze me how
difficult it is, on occasion, to find out how to do the simplest of
things in Excel VBA.

So how do I return the greater of two integers? In Pascal, it's Max(x,
y). I mean, don't all languages have that simple construction?

But my VBA compiler doesn't recognize "Max". Not only that, but "max"
and "maximum" don't even appear in the Contents and Index. Nor does
VBA Help's list of math functions even mention that functionality. I
find that to be unbelievable.

2. I should probably ask this in a different thread, but: I routinely
search microsoft.public.excel.* for answers to these basic syntax
questions, and I often find absolutely no hits whatsoever on even the
commonest questions. For example, I just searched
microsoft.public.excel.programming for various combinations of "max",
"maximum" "greater of", "integers", etc. and all I get are threads on
much more specialized topics.

Now, I use Google Groups' interface into Newsnet. Is that my problem?
Does Google present only a crippled subset of Newsnet to the world? If
so, how crippled? Pathetically so? Should I be using a true news
reader instead?

Thanks much.

***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of 15 random +/- integers always greater than or equal to zero MikeM Excel Programming 17 July 3rd 07 10:03 PM
How to pass arrays of integers or doubles to VBA function in Excel Bull Earwig Excel Programming 4 March 8th 07 11:12 PM
What function to select the last 3 smallest integers? Eric Excel Worksheet Functions 2 December 31st 05 01:39 PM
What function to select the last 3 smallest integers? Eric Excel Discussion (Misc queries) 4 December 31st 05 01:03 PM
A list of Consecutive Integers, can I search for missing integers CM Excel Worksheet Functions 4 September 2nd 05 06:38 PM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"