Vba

[pooja1994Participant]

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

Sent from my Redmi Note 5 using Tapatalk

[tacParticipant]

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.

[Author]

Posts