This function will return cell value of specific text that refers to cell address. In this video we talk about Indirect function in Excel and will see some examples of how to use this function
05 Definition of Module , Function and sub in VBA
In this video we introduce you the basic meaning of module , functions and sub in vba
INDEX function in Excel
Index function will return a cell value in intercept of specified row and column number in specific range
Match function in Excel
Match function will find a value in a row and then will return the row number of that value.
04 What object and class means in programming
Object oriented programming is on of the most important concepts in programming and we discuses what it means in this video
HLOOKUP Function in Excel
HLOOKUP function will help you to find a value in a row of sheet and will return another value from another row in same column of first value
03 VBA development Environment IDE
In this video we introduce you the VBA environment which is the IDE for writing and editing the VBA codes
www.deyako.co.uk
VLOOKUP NA ERROR
When VLOOKUP function resulted to NA, then it mean it can find the interested value in the table, however, there are the times that you have interested value in the table, still vlookup function results to NA error. In this video we talk about these situations and how it can be handled.
How to edit Macro code in VBA
Assume that you record a Macro in Excel and you want to change some of its code to make it more practical, so we need to go to the VBA environment and do our modification there
VLOOKUP Function in Excel
VLOOKUP function finds a value in a table or array and then return a value which is in the same row but another column