I am trying to write a macro that will copy and paste a formula to a specific row based upon my input in a certain cell. Therefore, one time I might need to have the macro copy and paste to row 25 and the next time the macro might be required to paste the formula to row 50. I have attached the file including the basic macro. Any help would be greatly appreciated. Thank you.
Change your macro to this:
I hope that helps.
Please Login or Register to view this content.
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
I added a line that will delete the rows in column B below B2, so that if you go from 50 to 25 you don't keep the lines below 25. I also got rid of most of the selections because it's best not to use them in my experience.
This is all the code you need
Please Login or Register to view this content.
Or:
Please Login or Register to view this content.
Kind regards, Harry.
thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks