Greatings All,
I have a listbox with some items (seres of dates). There are some dates mising, could anyone help me how I can determine those dates?
Thank you
Greatings All,
I have a listbox with some items (seres of dates). There are some dates mising, could anyone help me how I can determine those dates?
Thank you
GUURE
Hi,
just via if the difference between cells is greater than one or
recomputing the range from the difference again between last date and first date or …
It depends on how really is your worksheet and what result layout you expect.
Dear @Marc L
thanks for your response.
This is my desired result
It seems you missed the top page yellow banner as when I click on your 'attached' nothing happens within my Excel …
That was a picture. I guess data is simple
I now attached sample file, I want to NOT reference anything from the ListFillRange.
Thanls
Last edited by Axmed.cm; 01-15-2020 at 03:12 PM. Reason: I want to NOT reference anything from the ListFillRange
How do you anticipate interrogating the data if you do not want to access its source ???
Thanks dear, this is just an example, In my real data I am not using ListFillRange, I populate listbox at runtime. That's why I prefere to reference the listbox items
Last edited by Axmed.cm; 01-15-2020 at 04:19 PM.
So according to Sheet2 a beginner starter demonstration :
PHP Code:
Sub Demo1()
Dim V, R&, N%, S$
V = Sheet2.[A2].CurrentRegion.Columns(1).Value
For R = 2 To UBound(V)
For N = 1 To V(R, 1) - 1 - V(R - 1, 1)
S = S & V(R - 1, 1) + N & vbLf
Next N, R
If S > "" Then MsgBox S, vbExclamation, "Missing Dates"
End Sub
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks