Hi all
I have a list of names in cells A1:A11
Cells A3,A4,A7 and A9 are blank.
So can i have a code to display a list of non-empty cells only in a msgbox?
Thanks
Ahmedka
Hi all
I have a list of names in cells A1:A11
Cells A3,A4,A7 and A9 are blank.
So can i have a code to display a list of non-empty cells only in a msgbox?
Thanks
Ahmedka
GUURE
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
or:
Sub macro1()
Dim msg As String
For x = 1 To 11
If Not Cells(x, 1) = "" Then msg = msg & vbNewLine & Cells(x, 1)
Next x
MsgBox msg
End Sub
Thank you my brothers mehmetcik and dOOb..
it is well functioning. Especially the one from dOOb. I used it.
Last edited by Axmed.cm; 03-20-2016 at 08:18 AM. Reason: SOLVED
This should do...
Please Login or Register to view this content.
Thanks dear
that very helpful
is it possible to have a serial number for each line in the msgbox?
eg.*
1. Ahmed
2. Yasser
3. Khail
Thanks more
assuming you are still using my solution, just edit this line
Please Login or Register to view this content.
Please Login or Register to view this content.
dear dOOb and jindon
Thank you for your quick response
this writes the row number of the cell.
I need a serial number like 1 2 3
Thanks dear
I think the solutions provided are excellent
But try this
Please Login or Register to view this content.
Last edited by YasserKhalil; 03-25-2016 at 03:39 PM.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Thanks my brother khalil
for example
A1=Yasser
A2=""
A3=Khalil
then msgbox reads:
1. Yasser
3. Khalil
this means it reads row numbers and names
but I need msgbix to appear like this:
1. Yasser
2. Khalil
thanks my dear
I have edited post #10 .. try it now
Thank you all my dear friends.
it is SOLVED.
Have a good day..
@jindon, I was tried yours first but I think something went wrong in my side. it was already OK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks