Excel vba function asking for object required error 424

Hi,

I made the following change of adding range into the call function and proceeds. Now the code stops here

For c = 1 To sht.Range(rng).Rows.Count

Why is that ? do I not need to write sht.range ?

Bilal