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: 3
Default How can I sperate the module into two part and connecte the two part and work well?

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
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
Hiding part of VBA or a Module in Macro Iraj Excel Discussion (Misc queries) 3 March 23rd 12 11:47 AM
spreadsheet part and part without grid lines jan Excel Discussion (Misc queries) 2 April 26th 10 11:27 PM
Search/Match/Find ANY part of string to ANY part of Cell Value TWhizTom Excel Worksheet Functions 0 July 21st 08 08:16 PM
Copying Part of a row down part of a column Not Excelling Excel Discussion (Misc queries) 3 January 6th 06 11:58 PM
How do I work with part of a cell entry? JKB Excel Worksheet Functions 4 July 29th 05 11:09 PM


All times are GMT +1. The time now is 05:07 PM.

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"