I can answer 1 and 3 easily enough:

1) Rows("16:16").EntireRow.Delete
2) I'll let someone else explain this one. My methods for this are very primative.
3) Columns("E:E").EntireColumn.Insert
Columns("H:H").EntireColumn.Cut Destination:=Columns("E:E").EntireColumn. _
EntireColumn

Hope that helps.

-Ikaabod


Quote Originally Posted by Sonnich
> >

BESIDES, I'd like to know:

1) how can I delete an entire row (e.g. 16)?

2) how do I know the size of my sheet? For some H is the last one used,
for others I or L. There must be a function for this.

3) is there a way to move an entire coloumn, or insert one? Or to
delete one (same as row I asume)?

BR
Sonnich