Macro help!!

P

Pam

The info below is the code I have for a worksheet where my
macro should prepare a new row at the bottom of the data
for input. For some reason it works ok the first time,
but the second time it repeats the same routine on the
same row, preventing the user to advance to a newly
formatted row. Help!

Range("A3").Select
Selection.End(xlDown).Select
Selection.Copy
Range("A63").Select
ActiveSheet.Paste
Range("E63").Select
Selection.End(xlUp).Select
Application.CutCopyMode = False
Selection.Copy
Range("E63").Select
ActiveSheet.Paste
Range("G63").Select
Selection.End(xlUp).Select
Application.CutCopyMode = False
Selection.Copy
Range("G63").Select
ActiveSheet.Paste
Range("H63").Select
Selection.End(xlUp).Select
Application.CutCopyMode = False
Selection.Copy
Range("H63").Select
ActiveSheet.Paste
Range("I63").Select
Application.CutCopyMode = False
ActiveWorkbook.Save
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro problem 1
Trying to loop format on excel 1
Macro to fill to next field with data 4
insert a line 1
Repeating a Macro Based 2
Help linking true false in column to start macros 3
Macro - Whats wrong? 4
VBA Code To have a macro repeat on all sheets in a workbook 3

Top