Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand selected Rows
Hi there,
I am struggling with the following question, Your Help on this is Greatly appreciated: My Macro finds the last Row that I want to select somewhere in my spreadhseet (Not the last Row, but somewhere halfway) Now I want to Expand the selection, Starting with Row 3 up to the Row that I have just found. How do I do this? Again, I appreciate Your Help here, Thank You in advance!! Rgds, Hilvert Scheper |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand selected Rows
Hi Hilvert,
Would you like to post the code to find the initial row. It depends on what you have to determine how to satisfactorily answer your question. -- Regards, OssieMac "Hilvert Scheper" wrote: Hi there, I am struggling with the following question, Your Help on this is Greatly appreciated: My Macro finds the last Row that I want to select somewhere in my spreadhseet (Not the last Row, but somewhere halfway) Now I want to Expand the selection, Starting with Row 3 up to the Row that I have just found. How do I do this? Again, I appreciate Your Help here, Thank You in advance!! Rgds, Hilvert Scheper |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand selected Rows
Hi OssieMac,
Here's how I find and select the Row that I want: Cells.Find(What:="COMMENTS", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Select ActiveCell.Offset(-2, -4).Select Selection.EntireRow.Select Now the Row is selected that I want to be the Last Row, so now I want to Select Rows 3 up to this row. Many Thanks for Your help!! "OssieMac" wrote: Hi Hilvert, Would you like to post the code to find the initial row. It depends on what you have to determine how to satisfactorily answer your question. -- Regards, OssieMac "Hilvert Scheper" wrote: Hi there, I am struggling with the following question, Your Help on this is Greatly appreciated: My Macro finds the last Row that I want to select somewhere in my spreadhseet (Not the last Row, but somewhere halfway) Now I want to Expand the selection, Starting with Row 3 up to the Row that I have just found. How do I do this? Again, I appreciate Your Help here, Thank You in advance!! Rgds, Hilvert Scheper |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand selected Rows
Hi again Hilvert,
Cells.Find(What:="COMMENTS", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Select ActiveCell.Offset(-2, -4).Select Range(Rows(ActiveCell.Row), Rows(3)).Select You don't need the following row. 'Selection.EntireRow.Select -- Regards, OssieMac "Hilvert Scheper" wrote: Hi OssieMac, Here's how I find and select the Row that I want: Cells.Find(What:="COMMENTS", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Select ActiveCell.Offset(-2, -4).Select Selection.EntireRow.Select Now the Row is selected that I want to be the Last Row, so now I want to Select Rows 3 up to this row. Many Thanks for Your help!! "OssieMac" wrote: Hi Hilvert, Would you like to post the code to find the initial row. It depends on what you have to determine how to satisfactorily answer your question. -- Regards, OssieMac "Hilvert Scheper" wrote: Hi there, I am struggling with the following question, Your Help on this is Greatly appreciated: My Macro finds the last Row that I want to select somewhere in my spreadhseet (Not the last Row, but somewhere halfway) Now I want to Expand the selection, Starting with Row 3 up to the Row that I have just found. How do I do this? Again, I appreciate Your Help here, Thank You in advance!! Rgds, Hilvert Scheper |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand selected Rows
Fantastic,
Just what I needed, Thank You Very much indeed!!! Hilvert "OssieMac" wrote: Hi again Hilvert, Cells.Find(What:="COMMENTS", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Select ActiveCell.Offset(-2, -4).Select Range(Rows(ActiveCell.Row), Rows(3)).Select You don't need the following row. 'Selection.EntireRow.Select -- Regards, OssieMac "Hilvert Scheper" wrote: Hi OssieMac, Here's how I find and select the Row that I want: Cells.Find(What:="COMMENTS", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Select ActiveCell.Offset(-2, -4).Select Selection.EntireRow.Select Now the Row is selected that I want to be the Last Row, so now I want to Select Rows 3 up to this row. Many Thanks for Your help!! "OssieMac" wrote: Hi Hilvert, Would you like to post the code to find the initial row. It depends on what you have to determine how to satisfactorily answer your question. -- Regards, OssieMac "Hilvert Scheper" wrote: Hi there, I am struggling with the following question, Your Help on this is Greatly appreciated: My Macro finds the last Row that I want to select somewhere in my spreadhseet (Not the last Row, but somewhere halfway) Now I want to Expand the selection, Starting with Row 3 up to the Row that I have just found. How do I do this? Again, I appreciate Your Help here, Thank You in advance!! Rgds, Hilvert Scheper |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to minimize and expand the rows? | New Users to Excel | |||
How can I get the rows to expand before a total? | Excel Discussion (Misc queries) | |||
auto expand rows | Excel Worksheet Functions | |||
auto expand rows | Excel Programming | |||
Expand the Height of a form if "Not Managed" selected | Excel Programming |