Creating a macro

[Guest]

I am a new macro user. I have read the tutorials but cannot get the macro to
work. I use Excel 2000. Each time I run the macro it wipes out earlier
data. Part of the problem is trying of use the relative reference function
that my help guide says I get to by clicking on the Stop Reconding button.
However, I don't see any reference to Relative Reference. I am trying to use
the macro to take data (a long list of names and addresses) that is listed
vertically in excel and re-set it horizontally in separate cells. Are macros
the way to do this or is there a different way?

 

[JulieD]

Hi

the Relative Reference button is on the Stop Recording TOOLBAR which should
come up when you press OK after entering the macro name into the dialog box.
If the toolbar doesn't come up (only two buttons on it, the stop recording
one and the relative reference one), then choose view / toolbars / stop
recording and then you will see it.

macros are probably the way to go to do what you want ... there have been
questions on this topic in the past and people have posted sample code .. so
you might like to do a search at groups.google.com and see if you can find
these past posts.

Cheers
JulieD

 

[Guest]

It worked, thanks. We have found while using the macro that sometimes it is
unstable. Is this a typical problem?

 

[JulieD]

Hi

no not normally, if you'ld like to explain what you mean by unstable and
outline what problems you're having and then copy & paste your code into
your post we might be able to find a way to make it more stable.

Cheers
JulieD