Creating a macro
 

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?

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

"Macro Insite" <Macro wrote in message
...
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?

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

"JulieD" wrote:

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

"Macro Insite" <Macro wrote in message
...
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?

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

"Macro Insite" <Macro wrote in message
...
It worked, thanks. We have found while using the macro that sometimes it
is
unstable. Is this a typical problem?

"JulieD" wrote:

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

"Macro Insite" <Macro wrote in message
...
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?