Recent content by coolcp

Hi, How do we select the complete range in the excel file. For example, I hv files with different rows and cols and i wanted to write a code to copy the data frm these datasheets to another..so can't use the lines like Range(A1:AJ50).Select..I require somthing generic to change the range...