VBA Worksheetfunction

Thanks for that, however I am still wondering if VBA has its own function then does that mean we can't use the same function from excel? Why doesn't Rand() show up after I type worksheetfunction? (I have intellisense enabled)

Also what's the difference between say Worksheetfunction.NPV and Application.NPV, both codes calls upon the function NPV from excel but is there any differences between the two? When do we need to put worksheetfunction. in front of the function and when do we need to put Application. in front of the function?

Thanks