Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find max value in macro
I want to define a constant in my macro to be the maximum value in the range
from c2 to the the last row in column c. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find max value in macro
By definition a constant isn't variable. Unless you're trying to chnage
your code modules on the fly... You could set a variable to that value: Dim dMax As Double dMax = Application.WorksheetFunction.Max(Range("C2:C" & Rows.Count)) In article , Steve wrote: I want to define a constant in my macro to be the maximum value in the range from c2 to the the last row in column c. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find max value in macro
see your other post
"Steve" wrote: I want to define a constant in my macro to be the maximum value in the range from c2 to the the last row in column c. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find | Excel Discussion (Misc queries) | |||
Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
Find Macro | Excel Discussion (Misc queries) | |||
Macro - can't find | Excel Discussion (Misc queries) | |||
Cannot find macro | New Users to Excel |