I have this program where I look through all the rows in the excel file I use...
Set rngTPT = .Range("A1:A650")
but I dont want to have a range limitation. How can I go through the file but not give it a limitation?
I was trying .UsedRange.Value, but it kept giving me an error that the object variable or With block var not set...so I apparently am not using it correctly. Can anyone help?