macro

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

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

Macro

resolvedResolved · Low Priority · Version 2007

Darren has attended:
Excel Advanced course

Macro

Would Macro created in 2007 be compatible in 2010

RE: Macro

Hi Darren,

Thank you for your question and welcome to the forum.

Generally the answer is Yes unless the code in either version relates to features only available in that particular version.

You could copy the code from one vba window into another vba window in another workbook.

I hope this answers your question.

Regards

Simon

Thu 1 Dec 2011: Automatically marked as resolved.


 

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips


Server loaded in 0.1 secs.