Hi everyone,
I need a simple macro to make all cell values in a row static, based on the related value in column A. If the value in column A is empty, then just ignore it. Otherwise if the value is not empty, then make the whole row as static value.
For example, if cell A2 is not empty, then all values of row 2 are made static. If cell A3 is empty, then ignore row 3.
You are asking for how to do this for a row, so here is how to do it for a row. If you need to systematically review multiple rows then you will need to provide a little more information about the overall problem. This operates on the first 8 rows; this code should go in the module for the worksheet containing the data.
Please Login or Register to view this content.
Try this:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi Jeff, Arkadi, thank you for the great help. Your code both works nicely
Very welcome
Thanks for marking the thread as solved, and for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks