How to use range quotes. Having trouble understanding Range syntax

[gpxfiles77]

Below is my code. I just want to select the range from the activecell to the last cell used in the column. There may be blanks so I just want to go to the last cell used. FYI I use "t" in front of my variables to eliminate any possible conflict between my variable name and the possible chance that excel has one with the same name.

I cannot understand how when why to use the quotes for the Range. I am sure there are other problems with the code. Any help appreciated.

Please Login or Register  to view this content.

[pike]

Hi gpxfiles77
Maybe something like this?

Please Login or Register  to view this content.

[gpxfiles77]

Thank you for your post. I am a noob at this and this is my very first VBA program. It took me hours to write and understand it. Any comments on technique or structure or anything is appreciated. It doesnt do much, just selects the cells from the active cell down to the last used cell in that same column.

Please Login or Register  to view this content.