#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default ACTIVECELL LOCATION

I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6 or
6,2
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default ACTIVECELL LOCATION

ActiveCell.Address(False, False)

Regards,
Stefi

€žkt(uk)€ ezt Ã*rta:

I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6 or
6,2

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default ACTIVECELL LOCATION

Sub tryme()
MsgBox ActiveCell.Address
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kt(uk)" wrote in message
...
I would like to know if there is a macro command that will return the
position of the current activcell. This could either be in the format B6
or
6,2



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If activecell.column = variable then activecell,offset (0,1) Battykoda via OfficeKB.com Excel Discussion (Misc queries) 1 October 2nd 07 08:05 PM
ActiveCell in a Range? Filo Excel Discussion (Misc queries) 3 May 22nd 07 09:52 PM
highlight activecell flow23 Excel Discussion (Misc queries) 10 February 21st 06 12:01 PM
Activecell problem [email protected] Excel Discussion (Misc queries) 1 October 26th 05 02:13 PM
Defining an Activecell Ant Excel Discussion (Misc queries) 6 October 3rd 05 05:32 PM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"