Delete Rows
 

I think my question is too simple, because I've been searching through
these threads and can't seem to find the answer. All I want to do is
write into my macro the code to delete rows 1 and 2. That's it. Can
someone tell me what code to use? I'm afraid I'm a little too new at
designing macros. Thanks for your help!


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

Delete Rows
 

Try

Rows("1:2").Delete


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"andysgirl8800"

wrote in message
news:andysgirl8800.28ds9a_1148590202.0129@excelfor um-nospam.com...

I think my question is too simple, because I've been searching
through
these threads and can't seem to find the answer. All I want to
do is
write into my macro the code to delete rows 1 and 2. That's
it. Can
someone tell me what code to use? I'm afraid I'm a little too
new at
designing macros. Thanks for your help!


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

Delete Rows
 

Rows("1:2").Delete

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"andysgirl8800"
wrote in message
news:andysgirl8800.28ds9a_1148590202.0129@excelfor um-nospam.com...

I think my question is too simple, because I've been searching through
these threads and can't seem to find the answer. All I want to do is
write into my macro the code to delete rows 1 and 2. That's it. Can
someone tell me what code to use? I'm afraid I'm a little too new at
designing macros. Thanks for your help!


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

Delete Rows
 

thank you so much! knew it had to be simple! is it just as simple to
move column F to column A?


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

Delete Rows
 

To overwrite the existing Column A with Column F (and F is deleted)

Columns(6).Cut Columns(1)

To insert before column A and delete F

Sub AAB()
Columns(6).Cut
Columns(1).Insert
End Sub

--
regards,
Tom Ogilvy

"andysgirl8800"
wrote in message
news:andysgirl8800.28du3y_1148592602.1133@excelfor um-nospam.com...

thank you so much! knew it had to be simple! is it just as simple to
move column F to column A?


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