Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from) May 16th, 2021

Excel INDIRECT function – basic uses and formula examples (ablebits.com)

Posted in VBA || Comments Off on INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from)
Benefit for learning VBA May 2nd, 2021

Unlike macros, VBA enables you to do the following:

  • Work with complex logic structures (case statements, loops, and so on)
  • Take advantage of functions and actions not available in macros
  • Loop through and perform actions on recordsets
  • Perform transaction processing
Posted in VBA || Comments Off on Benefit for learning VBA
ParamArray August 22nd, 2020

The ParamArray keyword allows you to accept a dynamic number of arguments.
The word ParamArray is an abbreviation for parameter array.
Instead of using a large number of optional parameters it might be better to use a parameter array instead.…

Posted in VBA || Comments Off on ParamArray