Copy rows formatted and with same hidden colums

Well Im making a menu to be able to copy one row from "Sheet1" and paste it to the first empty row in "Sheet2", this works fine, but the rows in sheet1 is formatted (colum width, height) and there are alot of hidden colums with calculations that are'nt in the interest of the user.

So I wonder if anyone know a way of copy a row both formatted and with the same colums hidden. (I've tried paste special but it don't seem to make any difference)

I'll paste a screenshot and the code for easier understanding.

Please Login or Register  to view this content.

//Tobias

Hi,

My assumption would be that rows and/or columns are hidden at the "worksheet" level ... so copying entire sheet would replicate hidden areas.

Could selecting visible cells only help ?

HTH
Carim