Copy selected columns only
-----Original Message-----
I have a code to filter out data rows based on the filter
criteria and copy the same to first blank row available
in
a sheet called summary. But now I dont want to copy all
the rows. I want only filtered data of columns A, C, AD
and BA columns.
Any help is appreciated in this regard.
Regards,
Mac
.
Selection.SpecialCells(xlCellTypeVisible).Select will
select only the visible cells in the current selection.
These can then be pasted wherever you want them. It's the
same effect as F5, Sepcial..., Visible Cells Only
Cheers
Mark
|