Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the original module is :
Public Sub random() Dim cell As Range Dim count As Integer Randomize count = Selection.count For Each cell In Selection cell.Value = Rnd Next - - - - - - - - - - - - sperate the module from this For i = 1 To count Min = Application.WorksheetFunction.Min(Selection) For j = 1 To count If Selection(j) = Min Then Selection(j) = i End If Next j Next i End Sub How should I add or delet some moudle for connecte the two part ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding part of VBA or a Module in Macro | Excel Discussion (Misc queries) | |||
spreadsheet part and part without grid lines | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
How do I work with part of a cell entry? | Excel Worksheet Functions |