Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Discover line and columm that I selected

  Asked By: Pedro    Date: Oct 18    Category: MS Office    Views: 598
  

I´ve a little doubt when I try to discover the position that I selected in my
sheet, for example

Sheet
Considera Doc..Date
30.08.2006
s 07.09.2006
23.10.2006

Ho I know, what line and columm that I changed (the column in red that I put
"s") ?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Trae Thompson     Answered On: Oct 18

How are you trying to "know" the line  (row) and column?
When you make the change?
or afterward, look for the change?

Are you writing a script in VBA that you want to use to look for "s" in the
first column?

Are you wanting it to do something as soon as you make the change?

What is it that you are trying to do and how do you WANT it to work?

 
Answer #2    Answered By: Rochelle Elliott     Answered On: Oct 18

In VBA, using the Worksheet_SelectionChange event you can use
something like...

Cells(1,1) = Target.address

 
Didn't find what you were looking for? Find more on Discover line and columm that I selected Or get search suggestion and latest updates.




Tagged: