Macro Recorder

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have a very basic question( I think). When you are recording a Macro how
do you stop and then restart where you left off? For example I have a
repetitive task that moves columns from one spreadsheet to another. The
problem is that there are about 40 columns I am required to move.
As I record the macro can it be stopped and then restarted if I have to
close Excel and return later?
I can't find the answer to my question documented anywhere.
Thank You,
Greg
 
You can stop it, but when you start again it will create a new subprocedure,
you can go in and copy/paste the second after the first leaving out the 1st
end sub and the second one sub x
 
No but you can cut and paste the contents of two macros together after
you record them.
 
Why not tell us EXACTLY what you are trying to do. Which columns, etc and,
as always, post your efforts for comments.
 
Thank You all for responding. I can see how to use the copy/cut/paste
option...

Don, A little more background. Each Month I receive a 3 CDs with
Spreadsheets from one of our communications service providers. We update an
access database with the information from the CDs through the Access import
function. However we only choose the fields necessary for our Database from
the CDs. We actually concatenate the CD information from the CDs before we
update the DB and only do one import.

Jay, How will relative referencing help me? And what happens when our
service provider adds or deletes columns from the spreadsheets? Right now
with this macro I will have to change the macro(subprocedure)

Once again thank you all for your comments.

Greg
 
Don,
No reason not to post except the fact I have never completed the recording.
When I complete I will post.
Thanks to all again,
Greg
 
Back
Top