Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 46
Default Range of variables

I have 5 variable a, b, c, d, and e with numerical values. What is
the code for the Range to use in finding the min./

Thanks,

Ed
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Range of variables

mymin = Application.Min(a,b,c,d,e)

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
I have 5 variable a, b, c, d, and e with numerical values. What is
the code for the Range to use in finding the min./

Thanks,

Ed



  #3   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 46
Default Range of variables

Thank you


On Fri, 4 Aug 2006 23:00:57 -0400, "Tom Ogilvy"
wrote:

mymin = Application.Min(a,b,c,d,e)

Reply
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
Describing a Range with Variables mazo Excel Programming 2 May 9th 06 02:28 PM
How to use variables to define range Dolemite Excel Programming 4 August 12th 05 06:12 PM
Add up a Dynamic Range with 2 Variables John Excel Worksheet Functions 0 January 15th 05 02:00 PM
Naming Range Variables scott Excel Programming 6 January 7th 05 10:37 PM
Range Variables Daniel[_7_] Excel Programming 1 November 20th 03 05:45 AM


All times are GMT +1. The time now is 05:45 AM.

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

About Us

"It's about Microsoft Excel"