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 ar
very primative.
3) Columns("E:E").EntireColumn.Insert
Columns("H:H").EntireColumn.Cu
Destination:=Columns("E:E").EntireColumn. _
EntireColumn
Hope that helps.
-Ikaabod
Sonnich Wrote:
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 on
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
Sonnic
--
Ikaabo
-----------------------------------------------------------------------
Ikaabod's Profile:
http://www.excelforum.com/member.php...fo&userid=3337
View this thread:
http://www.excelforum.com/showthread.php?threadid=53555