To use name manager or create dynamic ranges in VBA

Hi. I currently have a userform that requires information from changing lists. I have defined the named ranges so far with

Please Login or Register  to view this content.

This works fine and ignores the fact if a cell is missing in the data. However I have read that this is bad practice to define dynamic ranges in vba and It slows code down the code(no idea if either of these statements is true). The alternative appears to be to use the name manager and type in

Please Login or Register  to view this content.

In my opinion this is the weaker option because if I accidentally delete a cell within row C the count will be one less and as such the bottom cell may have an input that is not captured within the range. Is there a workaround for this or if this method is used is it a case of make sure there are no gaps in the data?

APpreciate any comments on whether either of these methods are considered standard practice or if an laternative is preferred.

Many thanks Dave and cheers for the link. Will be using macros in my workbook so will stick with option 1