hi
this is my code in VBA
copy this sheet
Worksheets("Data").Range("A" & CheckRow & ":AK" & CheckRow).Copy
paste to new sheet
.Range(.Cells(nr, "A"), .Cells(nr, "AK")).PasteSpecial xlPasteValues
i have a few columns hidden on the master sheet that i am copyig from sheet data
therefore whn it pastes it is all off
how do i code to copy visible columns ony
and paste to the same visible columns on the new sheet
this is my code in VBA
copy this sheet
Worksheets("Data").Range("A" & CheckRow & ":AK" & CheckRow).Copy
paste to new sheet
.Range(.Cells(nr, "A"), .Cells(nr, "AK")).PasteSpecial xlPasteValues
i have a few columns hidden on the master sheet that i am copyig from sheet data
therefore whn it pastes it is all off
how do i code to copy visible columns ony
and paste to the same visible columns on the new sheet