how is it going on
how is it going on. I m wondering is that because i dong explain clearly? if so let me know i will explain a little bit more
Actually, i dont think the' Range("X65536").End(xlUp))' will work on the actual data. I have more 46 OR MORE COLUMNS IN THE real data, And the source workbook is to be refreshed with new data everymonth, which make the number of last row unknow. so I need a code to select from b5 to wherever the data end. and the end is unknow. I NEED code to command "go to the end of the data on the sheet"