Reply To: Vba

Actuary Forums › Forums › Learnings › Softwares › Excel VBA › Task › Macros › Recording macros and buttons › Vba › Reply To: Vba

September 6, 2019 at 2:15 am #24807
tac
Participant

    Pooja1994 wrote:


    What are the functions a Actuarial fresher should know in VBA?

    Sent from my Redmi Note 5 using Tapatalk

    Hi Pooja,

    Below listed are some functions that are generally used and everyone should be aware about them.

    Esle if, Creation of Macros,

    Assign macros to a button?

    Find last row or column in the worksheet,

    enable/disable screen updating

    save workbook using Excel VBA

    copy a file from one location to another location?

    delete row(s) or columns in the worksheet?

    Change the cell color?

    Change the range color?

    Hide/unhide a row(s) or column?

    Hide or unhide worksheets?

    Offset?

    Protect or UnProtect worksheet?

    Find last used row in a worksheet?

    Find last used column in a worksheet?

    Debug a VBA code?

    clear the content and formats in a Range?

    Clear the formats in a Range?

    Clear the Hyperlinks in a Range?

    Clear the Contents in a Range?

    Hope this will help. Feel free to ask anything about them.