All posts tagged "Function"

• 

  1.4K

  VBA

  VBA Function to Return Worksheet Name from Code Name

  I tried to find simple function to return the worksheet name from a Code Name. As I was searching, many said I...

• 

  2.2K

  VBA

  VBA Function to Browse & Select from Directory

  I have been building many applications using VBA to help users in automating processes. Somethings simply can’t be automated due to variability...

• 

  1.7K

  VBA

  VBA Function to Create New Excel Worksheet

  I was working on several VBA macros to automate several processes and I found myself repeating certain VBA code within each sub. ...