Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
address of activecell in another sheet
Hi All,
Is there a simple way to retrive the address of activecell in a sheet which is not the active sheet? Thanks, Stefi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
address of activecell in another sheet
Sub get_it()
Set whereami = ActiveSheet Sheets("Sheet2").Activate MsgBox (ActiveCell.Address) whereami.Activate End Sub -- Gary''s Student - gsnu200771 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
address of activecell in another sheet
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
address of activecell in another sheet
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 |
#5
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 |