| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start sub in Col B
I've goooogled this to death………….
How do I get a sub to start in Col B, on the same row as the selected cell? I could use offset, except I don't know where the selection will be. If I used a worksheet function it would be: =ADDRESS(ROW(),1,3) I know this is probubbly real simple, but I can't cipher it. Any help GREATLY appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start sub in Col B
Hi, Like this? Range("a10").Select Cells(ActiveCell.Row, "B") = "Here" ' ..... Or Cells(ActiveCell.Row, 2) = "Here again" HTH "Hugh" not.com" wrote: I've goooogled this to death€¦€¦€¦€¦. How do I get a sub to start in Col B, on the same row as the selected cell? I could use offset, except I don't know where the selection will be. If I used a worksheet function it would be: =ADDRESS(ROW(),1,3) I know this is probubbly real simple, but I can't cipher it. Any help GREATLY appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start sub in Col B
X-actly! (and thank you!!)
Toppers wrote: Hi, Like this? Range("a10").Select Cells(ActiveCell.Row, "B") = "Here" ' ..... Or Cells(ActiveCell.Row, 2) = "Here again" HTH "Hugh" not.com" wrote: I've goooogled this to death€¦€¦€¦€¦. How do I get a sub to start in Col B, on the same row as the selected cell? I could use offset, except I don't know where the selection will be. If I used a worksheet function it would be: =ADDRESS(ROW(),1,3) I know this is probubbly real simple, but I can't cipher it. Any help GREATLY appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm not sure where to start | Excel Worksheet Functions | |||
| Calculating monthly start date with a start date | Excel Worksheet Functions | |||
| start:1 and start:2 - how did i get 2 copies? | Excel Discussion (Misc queries) | |||
| OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
| Start spreadsheet with WinXP start | Excel Worksheet Functions | |||
Linear Mode
