Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move a row to the centre of my sheet Excel 2002
Hello All
I would like to run an excel spreadsheet maximized. Search for a cell with data that meets certain criteria. When a match is found move the row that the cell is in to the middle of my sheet. I have the search done,but I haven't figured out how to centre the row. Any help would be much appreciated, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move a row to the centre of my sheet Excel 2002
As always, you should copy/paste your coding efforts here. Do NOT attach a
workbook. -- Don Guillett SalesAid Software "Paul" wrote in message ... Hello All I would like to run an excel spreadsheet maximized. Search for a cell with data that meets certain criteria. When a match is found move the row that the cell is in to the middle of my sheet. I have the search done,but I haven't figured out how to centre the row. Any help would be much appreciated, Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move a row to the centre of my sheet Excel 2002
Sub AAA()
Dim rng As Range, numRows As Long Set rng = Cells.Find("ABCD") rng.Select numRows = Int(ActiveWindow.VisibleRange.Rows.Count / 2) If rng.Row numRows Then ActiveWindow.ScrollRow = rng.Row - numRows Else ActiveWindow.ScrollRow = 1 End If End Sub -- Regards, Tom Ogilvy "Paul" wrote in message ... Hello All I would like to run an excel spreadsheet maximized. Search for a cell with data that meets certain criteria. When a match is found move the row that the cell is in to the middle of my sheet. I have the search done,but I haven't figured out how to centre the row. Any help would be much appreciated, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to print in page centre? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to move to the next cell with content ? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to move to the last line of the active worksheet | Excel Discussion (Misc queries) | |||
How do I get "centre across selection" to centre properly? | Excel Discussion (Misc queries) | |||
Can I move Excel 2002 from my laptop to my desktop | Excel Discussion (Misc queries) |