Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select all odd-numbered rows in huge excel sheet?
Want to select all odd-numbered rows in a spreadsheet without going thru the
task of hand selecting each. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select all odd-numbered rows in huge excel sheet?
Enter and run this small macro:
Sub odds() Dim r As Range Set rr = Cells(1, "A") Set r = ActiveSheet.UsedRange nLastRow = r.Rows.Count + r.Row - 1 For i = 1 To nLastRow Step 2 Set rr = Union(rr, Cells(i, "A")) Next rr.EntireRow.Select End Sub If you are unfamiliar with VBA, See: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student "bgilliam" wrote: Want to select all odd-numbered rows in a spreadsheet without going thru the task of hand selecting each. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't paste in excel without having an open excel sheet! | Excel Discussion (Misc queries) | |||
extract odd numbered rows from one sheet to put into another? | Excel Discussion (Misc queries) | |||
view excel sheet tabs in multiple rows | Setting up and Configuration of Excel | |||
How can I read over than 65,536 rows from excel spreed sheet | Excel Discussion (Misc queries) | |||
How do I select multiple rows randomly in MS Excel? | Excel Discussion (Misc queries) |