Rows(1).Resize(2).Delete

Turn the macro recorder and do one move manually.

Turn off the macro recorder and look at the code.

Should give you some insights.

--
Regards,
Tom Ogilvy

"andysgirl8800"
wrote in message
news:andysgirl8800.28d99y_1148565604.3053@excelfor um-nospam.com...

That looks easy enough! but the overall coding seems different than
what I'm used to from access. can I also rearrange columns after I've
deleted the ones I don't need? in other words, if I use
Range("A:A,C:C,E:F,J:K,L:L,O:P").EntireColumn.Dele te, how do I then:
1) delete rows one and 2, moving all data below row one up.
2) arrange columns by header names in the order of:
"Receipt Date" as column A
"Member Number- Person Code" as column B
"Auth Number" as column C
"Brand Name" as column D
"Plan Status" as column E
"Fill Count" as column F
3) Insert a new column between columns A and B and between columns E
and F

To date, all of this has been done manually every day. I would like to
automate as much of this process as possible. I thought the code would
be like it is for access, but reading through the code, it doesn't make
much sense to me.


--
andysgirl8800
------------------------------------------------------------------------
andysgirl8800's Profile:
http://www.excelforum.com/member.php...o&userid=34752
View this thread: http://www.excelforum.com/showthread...hreadid=545141