How does this VBA code work?

[wonderdunder]

Some kind soul provided me with this sample code which will populate a userform omitting rows where a cell is blank in column C (have attached the sheet).

I'm trying to adapt it to a sheet where there are 22 columns (A - Q), and it is if a cell in column M is blank that the user form should show.

Unfortunately I don't seem to understand the syntax of the code. I think the "Count, 3" bit is throwing me off.

If someone could quickly explain it to me I'd be most appreciative.

Please Login or Register  to view this content.

[JosephP]

Please Login or Register  to view this content.

[wonderdunder]

offending 2 words removed. Can I see the "hidden" responses please or shall I go to the the naughty corner?

[JosephP]

Please Login or Register  to view this content.

is what I said before...

[royUK]

The title doesn't really describe the problem - something like explain code that loads userform.

However, there's absolutely no point in looping through the range, just refer to all the non blank cells using Specialcells

Please Login or Register  to view this content.

[wonderdunder]

Roy - many thanks. I'm trying to adopt this code so that the drop down box will only show data in column C if the cell in column M of the same row is not blank, but I do not understand the syntax of the code (as per my first post). Can you or someone else explain the code or if not provide the code amendments that will do as I need it to?

[royUK]

Here'an explanation of my coe

Please Login or Register  to view this content.