Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel VBA
Hi,
I would like to achieve two things in my excel vbscript. 1. check if there is any value in any cell in a column 2. If there is/are value(s), find the Highest value. Any helps ? Magix |
#2
|
|||
|
|||
See response in public.excel
-- HTH RP (remove nothere from the email address if mailing direct) "magix" wrote in message ... Hi, I would like to achieve two things in my excel vbscript. 1. check if there is any value in any cell in a column 2. If there is/are value(s), find the Highest value. Any helps ? Magix |
#3
|
|||
|
|||
You could use worksheet functions in your code to do this. for example:
Application.WorksheetFunction.Count(ActiveSheet.Ra nge("H:H")) will return a msg box with the number of cells that return a value in column H. Create an if statement for 0.....etc. Application.WorksheetFunction.Large(ActiveSheet.Ra nge("H:H"), 1) will return the larges value in column H HTH "magix" wrote: Hi, I would like to achieve two things in my excel vbscript. 1. check if there is any value in any cell in a column 2. If there is/are value(s), find the Highest value. Any helps ? Magix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |