ScoobyNet.com - Subaru Enthusiast Forum

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)

- Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)

- - Excel VB Macros (https://www.scoobynet.com/computer-and-technology-related-34/230206-excel-vb-macros.html)

DJ Dunk

15 July 2003 04:27 PM

I'm still used to using the old Excel 4.0 macros :o How do you make it record macros using relative rather than absolute references in the VB version ?

Thanks :)

Bajie

16 July 2003 08:43 AM

When you press the Record Macro button on the toolbar that appears is the Relative/Absolute toggle. Press this to switch between the two.

DJ Dunk

16 July 2003 08:46 AM

Bajie - Nice one, thanks :) Never noticed that :o

Bajie

16 July 2003 09:03 AM

No worries DJ :cool:

Transition to VBA is not so bad. Been using it since they changed with Excel 5.0. Frustrating to begin with but if you save one of your old Macro's to a newer version of Excel it will convert the code for you. Then have a look at the new code and see what you make of it.

Good Luck :)

All times are GMT +1. The time now is 02:27 AM.