I tried looking for an answer to this, but can't find what I need.
I need a VB code that will generate a Y or N randomly in a range of cells (L7:L50) if there are no blank cells in J7:J50. If a cell in column J7:J50 is blank, then the VB code would do nothing.
Can anyone help?
Thanks.
Check this okie?
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thanks for the help, but your code needs some tweaking. It will fill in cells (L7:L50) with Y or N when there is information in that range. Could you please adjust your code so that it fills in cells (L7:L50) with Y or N when there is information in cells (J7:J50)?
I don't know how to adjust your code to do that. Thanks.
Check thisPlease Login or Register to view this content.thanks
Thanks. It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks