Dazed & Confused
New Member
- Joined
- Jul 29, 2010
- Messages
- 3
Hi Members, I'm not sure if this is possible i've just started playing around with Excel, im trying to figure out if i can create a macro to copy & paste a formula in a single column cell by cell very basic this is as far as I have got...
Sub Macro1()
Range("E1").Select
Selection.Copy
Range("E2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Which is not very useful to me I was hoping to run 1 macro to copy Range E1 E2, E2 E3,
E4 E5, E6 E7 and so on. I may be asking too much. I'm using 07 Thanks.
Sub Macro1()
Range("E1").Select
Selection.Copy
Range("E2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Which is not very useful to me I was hoping to run 1 macro to copy Range E1 E2, E2 E3,
E4 E5, E6 E7 and so on. I may be asking too much. I'm using 07 Thanks.