Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

End (xlDown) question

I want to go to the end of column J, move up two rows, and delete the
last three rows. I'm just not sure how to get the delete range to
vary as I need it to. See code below:

Range("J2").Select
Selection.End(xlDown).Offset(-2, 0).Select
Rows("160:162").Select
Selection.Delete Shift:=xlUp
End Sub

Thanks in advance for your help!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A1:B(xlDown)?	Simon[_2_]	Excel Programming	5	July 29th 08 10:23 AM
End(xlDown) not working?	RAHokie	Excel Discussion (Misc queries)	2	January 19th 07 12:40 AM
xlDown going further than data	Astello[_2_]	Excel Programming	2	November 15th 06 07:45 PM
End(xlDown) won't work	mike	Excel Programming	12	September 16th 06 08:50 AM
End(xldown) not always going to last cell?	Duncan[_5_]	Excel Programming	6	May 4th 06 10:30 AM

All times are GMT +1. The time now is 02:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us