Finesse It Solutions

20/08/2015

Free seminar on changing trends in IT / ITES industry on Sunday 23-August at bhel chowk, pradhikaran Nigdi.. Learn VBA, advanced Excel, macros and database concepts from industry experts and know the secrets to crack interviews. Contact - 8793435479, 8805523477.

14/06/2015

First look of our Android app.

26/01/2015

26/01/2015

Hi Everyone,
We are working on a Book on VBA which will include all our notes and example macros. So that you can refer them any time. Kindly share your feedback.
Thanks.

26/01/2015

Ques 05. How to debug a VBA code?
Solution: Using Breakpoints(F9), Step-by-step ex*****on (F8), Debug.Print & Immediate Window and Watch window.

26/01/2015

Ques 06. Difference between ActiveX and Form Controls.

Solution:
i) Forms controls can be used on worksheets and chart sheets. Forms controls can also be placed within embedded charts in Classic Excel (though not in Excel 2007). ActiveX controls can only be used on worksheets. ActiveX controls do not work in MacExcel.
ii) The Forms controls aren’t very complicated, and they have been part of Excel for longer (they were used in Excel 5/95’s dialog sheets) than the Controls Toolbox (Excel 97), so it stands to reason that they’d be more seamlessly integrated. Being newer, the ActiveX controls have richer formatting possibilities. Both can link to cells and ranges in the worksheet.

26/01/2015

Ques 04. Difference between ActiveWorkbook and ThisWorkbook.
Solution: ThisWorkbook refers to the workbook where code is being written while ActiveWorkbook refers to the workbook which is in active state with active window. In case of only one workbook open, ActiveWorkbook is same as ThisWorkbook.

19/01/2015

Ques 03. Draw basic Excel Object Model.

Solution: Application --> Workbooks --> Worksheets --> Range / Chart

19/01/2015

Ques 01. Code to find a Last used Row in a column or Last used column of a Row.

Solution: Last Row in a column can be find using End(xlUp). For e.g. Range("A1048576").End(xlUp).Row gives last used row of Column A.

19/01/2015

Ques 02. What is the meaning of Option Explicit and Option Base?

Answer: Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. For eg. Option Base 1 will make the array lower bound as 1 instead of 0.

08/01/2015

Weekend batch schedule

08/01/2015

Daily Batch Schedule