Hi everyone,
I have a macro to make cells of selected range static as below. But it is not very efficient if I want to select some columns (or rows) and make them static (I usually copy and paste for the selected columns).
Do you have a better macro to allow me to select some columns and make the values static more efficiently? that is to make the entire column (or row) static.
Please Login or Register to view this content.
Hi billj,
The following will work if the cells are all contiguous. If you skip a row or a column, faulty results will occur with the following code:
The following code should work if the cells are NOT contiguous:Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
Last edited by LJMetzger; 12-15-2015 at 11:41 AM. Reason: Added 2nd macro
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Many thanks, walruseggman. It works nicely
Many thanks, Lewis. It is a good piece knowledge for me. Great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks