Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To a Named Range (2nd posting)
I posted my question about three weeks ago. I have several views but nobody informed me if it is possible or not.
I have several named ranges in my worksheet. If I go to one, is it possible that when it goes to that named range, the named range will be positioned at the upper left part of the worksheet (in a blank worksheet the named range would be at A1). Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To a Named Range (2nd posting)
It happens that formulated :
I posted my question about three weeks ago. I have several views but nobody informed me if it is possible or not. I have several named ranges in my worksheet. If I go to one, is it possible that when it goes to that named range, the named range will be positioned at the upper left part of the worksheet (in a blank worksheet the named range would be at A1). Thanks Application.Goto Range("RangeName"), Scroll:=True -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
|
|||
|
|||
Quote:
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To a Named Range (2nd posting)
On Sun, 24 Feb 2013 19:02:34 -0500, GS wrote:
It happens that formulated : I posted my question about three weeks ago. I have several views but nobody informed me if it is possible or not. I have several named ranges in my worksheet. If I go to one, is it possible that when it goes to that named range, the named range will be positioned at the upper left part of the worksheet (in a blank worksheet the named range would be at A1). Thanks Application.Goto Range("RangeName"), Scroll:=True My script moves to the sheet first, in case it is not the current... Sheets("Sheetname").Select Range("RangeName").Select Those are for single cell assignments, however. I do not know how a table would respond. It likely highlights the whole named range. But I do not know. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To a Named Range (2nd posting)
On Sunday, February 24, 2013 11:11:21 AM UTC-8, wrote:
I posted my question about three weeks ago. I have several views but nobody informed me if it is possible or not. I have several named ranges in my worksheet. If I go to one, is it possible that when it goes to that named range, the named range will be positioned at the upper left part of the worksheet (in a blank worksheet the named range would be at A1). Thanks Maybe this modified code by Chip Pearson will do the trick for you. I entered all the names of my named ranges in a data valadation drop down in F1. Select a name from F1 and run the Sub LHK(). Option Explicit Sub LHK() Dim i As String i = Range("F1").Value CenterOnCell Range(i) End Sub Sub CenterOnCell(OnCell As Range) Dim VisRows As Integer Dim VisCols As Integer Application.ScreenUpdating = False OnCell.Parent.Parent.Activate OnCell.Parent.Activate With ActiveWindow.VisibleRange VisRows = .Rows.Count VisCols = .Columns.Count End With Application.Goto OnCell, Scroll:=True OnCell.Select Application.ScreenUpdating = True End Sub Regards, Howard |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To a Named Range (2nd posting)
On Monday, February 25, 2013 8:32:46 AM UTC-8, wrote:
On Sunday, February 24, 2013 11:11:21 AM UTC-8, wrote: I posted my question about three weeks ago. I have several views but nobody informed me if it is possible or not. I have several named ranges in my worksheet. If I go to one, is it possible that when it goes to that named range, the named range will be positioned at the upper left part of the worksheet (in a blank worksheet the named range would be at A1). Thanks Maybe this modified code by Chip Pearson will do the trick for you. I entered all the names of my named ranges in a data valadation drop down in F1. Select a name from F1 and run the Sub LHK(). Option Explicit Sub LHK() Dim i As String i = Range("F1").Value CenterOnCell Range(i) End Sub Sub CenterOnCell(OnCell As Range) Dim VisRows As Integer Dim VisCols As Integer Application.ScreenUpdating = False OnCell.Parent.Parent.Activate OnCell.Parent.Activate With ActiveWindow.VisibleRange VisRows = .Rows.Count VisCols = .Columns.Count End With Application.Goto OnCell, Scroll:=True OnCell.Select Application.ScreenUpdating = True End Sub Regards, Howard Thanks Howard and to everybody that replied. I thought that were was an easier way to do it instead of a macro. When I go to a range, I'll just scroll down to it. Thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Named rnage and Add Named Range | Excel Programming | |||
Selecting a named range, the name of the named range is in a cell | Excel Programming | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
If any cell in named range = 8 then shade named range | Excel Programming | |||
the owner of posting should be able to delete the posting | Excel Discussion (Misc queries) |