Hi

I want to use VBA to copy columns a,b,c,e,f,g (excluding D as this is hidden)
together with the last 6 columns that have values in, into another sheet. The
cells that are blank do have formulas in them, but appear blank. My main data
starts in row 4, with the other rows above being column headers etc.. I have
attempted to record a macro, and inserting activecell.end(xltoright), which
gets me to theend cell, but get stuck on how to copy the preceeding 5 columns

Any direction/coding appreciated

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1