| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
VBA code to populate 1000's of cells?
Well the advantages of using the VBA function instead of the Excel
function is that is would run faster and would not have to be converted to constants. You make the selection beforehand, so that you would not have to change any range in the macro. Usually when I write a macro with a selection, it is limited to the used range. This macro is an exception. You must preselect the exact range you want from one cell on up. As far as being the same algorithm is concerned, I have no idea. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "nomail1983" wrote JE and David (or anyone else), can you comment on VBA Rnd v. Excel RAND(). Are they the same algorithm? if not, is one known to be better than the other? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
| REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Threaded Mode
