Select Range based on COmboBox selections

Why Does VBA hate this syntax?

Sheets("Summary").Range(Cells(TStart, 1), Cells(TEnds, 1)).Select

I use it, it works once and then try and use it again and Run Time Error Application Defined Error Object Error. I'm kind of lost

Really all I'm trying to do is be able to select the range start and end based on Combobox selections so combo box 1.value = TStart, ComboBox TEnds = End.

Please Login or Register  to view this content.

See if this works?

Please Login or Register  to view this content.

This works, but I have no earthly idea why. Further Why would the other way work initially and then come to a screaming halt. It's really bizarre