Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel vba - macro

ResolvedVersion Standard

Tim has attended:
Excel Advanced course
PowerPoint Introduction course

Macro

is there a way to put functions in a macro

RE: macro

Yes. Select the cell of your result first, then start recording a macro (name & assign shortcut key), insert the function as usual, then stop record the macro.

Hope this helps.

Katie

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.