Hi,
How to copy the cell which has formula by using macro
* I need to copy the 1500 cells in one column and paste into multiple times [20]
Attached sheet for referance...
1.The sheet is opening with 16 column
2.If i give input as 20, further 4 columns to be added [ Not affecting the column 'U' ]
Please guide me to solve the same.
-Sugavanam
You can record a macro doing this....
menubar/edit/goto.../formulas
You can use this code. I have tested it, complete with the inputbox and even the columns get numbered accordingly.
Please Login or Register to view this content.
Thanks,
Arlette Aloysius
If this was useful then please rate it appropriately.
Try this workbook
Run the macro "ColsRequired"
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Marcol,
I have also tested the code you provided to see on how i can better my code. I observed that your code doesnt copy the formulae across to the new columns. That is what sugavanam wants.
The question is, what formula?
If you are refering to =SUM(D4:R4), originally in T4, then I don't see the logic in this remaining unchanged if columns are added, as Column T is "Total No" surely this should total the row? ...
My logic says that this should actually be =SUM(D4:S4).
Column U doesn't have a formula, do you think sugavanam means Column T should remain unchanged?Not affecting the column 'U'
Check the formula I have in "Total No" after you run the code.
P.S. the only other formulae I can see are =I552*#REF! and =J552*T560 in columns I & J, they look like mistakes to me.
For your benefit look at these rows of code as a way to avoid loops
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks