Macro Question

C

carl

I am using this:


Sub Macro8()
Range("G6").Select
Selection.Copy
ActiveCell.Offset(-4, -6).Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.Run "checktrades.xls!Macro2"
Range("A2:B2").Select
Selection.Copy
ActiveCell.Offset(2, 0).Range("A1").Select
Selection.End(xlToRight).Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub

I have a list in G6:G10 and was wondoring if this part of the macro -

Range("G6").Select
Selection.Copy

Can it be modified to start with G6 and progress thru the list to G10.

Thank you in advance.
 
B

Barb Reinhardt

You could do the following:

For i = 6 to 10
Range("G" & i ).Select
Next i

Include whatever functionality you want withint the FOR NEXT loop.
 

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


Top