Hi, i meet the following problem, a have excel sample with functions from A-Z and rolls 1-2000 into sheet "A" . I paste data to this sample less than 2000 rolls, so could be for axample only 500 rolls from 1 - 500 . Than a have macros selecting this table and paste all data into new sheet "B", but paste only Values for reason. But after that i have another macros selecting the new sheet "B" , and the problem is here: It selects all 1-2000 rolls from the sheet "A", even if NO data in 501 - 2000 rolls, becouse i paste only Values in the previous action, and i dont want to be selected? I guess there is simple solution?
Thanks,
Vladimir
Bookmarks