LinkBack URL
About LinkBacks
I want the run the code below, however in the range C6:AB83 I want to ignore blank cells. I'm guessing If cell <> "" Then run code would do the trick but I'm not sure where to insert. Could you help?
Please Login or Register to view this content.
I want the run the code below, however in the range C6:AB83 I want to ignore blank cells. I'm guessing If cell <> "" Then run code would do the trick but I'm not sure where to insert. Could you help?
Please Login or Register to view this content.
Last edited by Chris220; 07-15-2019 at 10:58 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Try adding this linePlease Login or Register to view this content.
Perfect thanks, is there anyway I could also adjust the code to ignore merged cells. every time I click on merged cells an error appears called run-time 13.
Code can be adapted to deal with merged cells, but if you just want to skip those then either before or after the If Target = "" you can put:
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.
Best way is to get rid of the merged cells, they should be avoided like the plague and will only give massive amounts of grief.
If you have to keep them tryPlease Login or Register to view this content.
Advice taken I'll get rid of merged cells
Glad to hear it, not only does VBA hate them, but they interfere with sorting, filtering & some formulae.
If the cells are merged horizontally rather than vertically, you can get a similar visual affect using "Center across selection"
https://www.atlaspm.com/toms-tutoria...merging-cells/
Thanks for the Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks