| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
address of activecell in another sheet
Thanks, Henn, I'll give it a try tomorrow!
Stefi Henn Sarv ezt *rta: Not only :) Quite funny and useless Worksheet function: Function ACEll() As String Application.Volatile (True) Dim s As Worksheet Set s = ActiveSheet ActiveWorkbook.ActiveSheet.Select ACEll = ActiveSheet.Name + "!" + ActiveCell.Address() s.Select End Function Try - this really works :) Henn "Stefi" kirjutas sõnumis ... Thanks! I was not specific enough, I hoped that there is a simpler way than that. I'm satisfied because there is not an additional lack of my knowledge. Stefi Gary''s Student ezt *rta: Sub get_it() Set whereami = ActiveSheet Sheets("Sheet2").Activate MsgBox (ActiveCell.Address) whereami.Activate End Sub -- Gary''s Student - gsnu200771 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveCell.Address question | Excel Programming | |||
| How can i get activecell address | Excel Programming | |||
| identify the name of the activecell not its address | Excel Programming | |||
| Activecell address | Excel Programming | |||
| ActiveCell.Address | Excel Programming | |||
Hybrid Mode
