Set myRange = Worksheets("Sheet1").Range("A1:C10")Īnswer = (myRange) Finally, the value of answer is displayed in a message box. Another variable, answer, is assigned the result of applying the Min function to myRange. First, the variable myRange is declared as a Range object, and then it is set to range A1:C10 on Sheet1. The following Sub procedure uses the Min worksheet function to determine the smallest value in a range of cells. In Visual Basic, the Excel worksheet functions are available through the WorksheetFunction object. Calling a worksheet function from Visual Basic For example, the Concatenate function is not needed because in Visual Basic you can use the & operator to join multiple text values. Some worksheet functions are not useful in Visual Basic.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |