Macro - paste a row for a certain num of rows below

[mazaman]

Hello,

Say I have a row with data in row 3 while my selection is a couple of rows below row 3. (All the cells are empty below row 3)

From my current location, I reach the row 3 and while performing a count of the number of rows elapsed to get to the row with data. After recording this macro manually (using a row count macro ofcourse), this is the code that got generated so far:

Range(Selection, Selection.End(xlUp)).Select 
Application.Run "Results_BW.xls!CountRow" 

Where the code for CountRow is:

Sub CountRow() 
myCountRow = Selection.Rows.Count

All I would like to know is how to get Excel to copy a row a certain number of rows below it, where the number is the row count I just performed.

If there is any need for further clarification then please let me know! Any help is appreciated.

[Leith Ross]

Hello mazaman,

Welcome to the Forum!


To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

Use the Bulletin Board Code Tags
[code] at the start of the first line,
[/code] at the end of the last line.