Vba Return Worksheet From Function. Log and Log will return different values. Some worksheet functions are not useful in Visual Basic.
Visual Basic for Applications (VBA) has many built-in functions that help you work with spreadsheet data. You need to use a VBA code or the properties. When you are working with VBA inside Excel, it is more than likely that you will be automating some sort of changes to a worksheet inside your file.
However, the limitations of VBA sometimes make it necessary for a procedure to.
I expected that returning type will be a Worksheet object.
But Excel is the undisputed king when it comes Fortunately, you can use worksheet functions to take advantage of that power when you're writing macros in VBA. In the WORKSHEET module: [vba]Option Explicit. For example, I have a functioning code like so. wSheet already dim'ed: Public wSheet As Worksheet.