I want a macro to copy a portion of a column of numbers. The number of cells copied changes each month.
In the attached sample cell D1 has the number of cells to be copied. The cells I want to copy are in column B. in the sample I want to copy the first 15 cells in column B i.e. 1 through 17.
Thanks
copy to where?
also i think your confusing columns with rows
also does column A do anything here?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Sorry about the confusion. I knew how to make the macro paste so I did not include pasting in my request. The numbers in column A is just a counter.
I just ran the macro you suggested and it worked great. It is what I needed.
Sub CopyRange() ' deletes whatever is in column F....remove this code if not required Range("F:F").Delete 'Just selected F1 for this example but you can change to whatever you want Range("B1:B" & Range("D1").Value).Copy Range("F1") End Sub
just change the number of cells you want to copy. the output would be reflected in column F.
To look at the code click on the programmer option and then click on view code.
Thank for the reply. Your method requires the macro to be changed each month. humdingaling's macro gives me the result without changing the macro each month.
Cheers
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
socalobie 
Register To Reply
Bookmarks