|
-
Oct 28th, 2004, 12:29 PM
#1
Excel Macro Question
I have a very simple Excel macro consisting of
Rows("271:271").Select
Selection.Copy
Selection.Insert Shift:=xlDown
How can I change it so that it selects the currently selected row rather than row 271?
The currently selected row will always be the row above the first row of some totals, so ideally I'd like the macro to find the total row and do the copy and insert always using the row above it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|