excel vba - macro
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba - Macro

excel vba - Macro

resolvedResolved · Low Priority · Version Standard

replyReply Wed 22 Aug 2007, 15:55Delegate Tim said...

Tim has attended:
Excel Advanced course
Powerpoint Introduction course

Macro

is there a way to put functions in a macro

For upcoming training course dates see: Pricing & availability

replyReply Thu 30 Aug 2007, 14:24Trainer Katie said...

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:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard