relative macros

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Relative Macro's

Relative Macro's

resolvedResolved · Low Priority · Version 2003

Adam has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Relative Macro's

Quick question, I know about Macro's now, but in what situation would you use a relative Macro?

RE: Relative Macro's

Hi Adam,

Thank you for your question.

I have found an example below that uses Relative referencing to take a row record and change it so the record is in a column.

http://www.mrexcel.com/articles/record-modify-run-excel-macro.php

I hope this helps.

Regards

Simon

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.