hi all , i need to be able to select only visible rows and columns that contain data, eg if columns A,B,C,D,E up to row 26 for example, then i want to select this group, copy it and then transfer it all to sheet 2, (even if there are a couple of blanks in the selection i want to include them also) if more rows of data is included then they will be included as well, if this is possible then can it be used in a macro? and if so how do i go about it please?