Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code...
Dim x1 As Integer Dim x2 As Integer Dim x3 As Integer Columns("B:B").Select Selection.Find(What:="miscellaneous", After:=ActiveCell, LookIn:= _ xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _ xlNext, MatchCase:=False, SearchFormat:=False).Activate x1 = ActiveCell.Row Columns("A:A").Select Selection.Find(What:="ms totals", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate x2 = ActiveCell.Row x3 = (x1:x2) Rows(x3).Select With this I am attempting to extract a few rows. I search for "Miscellaneous" in column B, save the row number as x1. Search for "ms totals" in column A, saving the row number as x2. All I want to do is Select the Rows between those two numbers, seems easy probably is. I will be very grateful to anyone who can help me at all, thanks a lot. Nick Cherry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
selecting variable rows in a macro that creates a pivot table | Excel Programming | |||
selecting range of cells - variable # of rows | Excel Programming | |||
Selecting Variable Rows | Excel Programming | |||
Selecting a row with a variable ? | Excel Programming | |||
Selecting rows with variable | Excel Programming |