| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
place a named cell in the top left corner of the worksheet
I am writing a simple routine but am a novice at this. I want to 'go to'
various named cells and I always want the cell I go to, to be positioned at the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can anyone help please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
place a named cell in the top left corner of the worksheet
one way:
Application.GoTo Range("namedcell"), Scroll:=True In article , Paul Condron <Paul wrote: I am writing a simple routine but am a novice at this. I want to 'go to' various named cells and I always want the cell I go to, to be positioned at the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can anyone help please? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
place a named cell in the top left corner of the worksheet
Thank you very much.
"JE McGimpsey" wrote: one way: Application.GoTo Range("namedcell"), Scroll:=True In article , Paul Condron <Paul wrote: I am writing a simple routine but am a novice at this. I want to 'go to' various named cells and I always want the cell I go to, to be positioned at the top left hand corner of the worksheet. E.g. a:1 or aa:100 or BB:500. Can anyone help please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| can't move a named cell without breaking a hyperlink to that cell | Links and Linking in Excel | |||
| How do I place an excel worksheet name in a cell? | Excel Worksheet Functions | |||
Linear Mode
