If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
big stupid question
In a marco,
If I write --- EN = cells(1,1) then, EN will equal to the data of cells(1,1) The problem is : The cursor will stop at different cell, not certain. May be at cells(2,2), cells(3,10), cells(10,2)............., every time is different. So, I want to get the location of the cell, then set EN is equal to that cell. How to write in marco to get the location of cells. |
#2
|
|||
|
|||
big stupid question
Try...
EN = ActiveCell.Value Rick "Wu" wrote in message ... In a marco, If I write --- EN = cells(1,1) then, EN will equal to the data of cells(1,1) The problem is : The cursor will stop at different cell, not certain. May be at cells(2,2), cells(3,10), cells(10,2)............., every time is different. So, I want to get the location of the cell, then set EN is equal to that cell. How to write in marco to get the location of cells. |
#3
|
|||
|
|||
big stupid question
If you want the location(address)
Sub goop() EN = ActiveCell.Address 'MsgBox "address is " & EN End Sub Otherwise, see Rick's reply for returning the value. Gord Dibben MS Excel MVP On Fri, 16 May 2008 22:09:00 -0700, Wu wrote: In a marco, If I write --- EN = cells(1,1) then, EN will equal to the data of cells(1,1) The problem is : The cursor will stop at different cell, not certain. May be at cells(2,2), cells(3,10), cells(10,2)............., every time is different. So, I want to get the location of the cell, then set EN is equal to that cell. How to write in marco to get the location of cells. |
#4
|
|||
|
|||
big stupid question
Are you looking for a certain value, and then you'd like to get the
address of that cell? "...cursor will stop at different cell, not certain..." Or are you just wanting the address of whatever cell is active at the time? If you're looking for something, and then would like to get the address of that cell, you will need a Cells.Find(.......) function. Then you could make an if statement to display cell address. Dim mySearch as Range On Error Resume Next Set mySearch = Cells.Find("____") If mySearch.Value = _____ Then MsgBox (mySearch.Address) End If .....something to that effect. Have to debug a little better, but that's basically it. dk |
#5
|
|||
|
|||
big stupid question
Check one of your other posts, too.
Wu wrote: In a marco, If I write --- EN = cells(1,1) then, EN will equal to the data of cells(1,1) The problem is : The cursor will stop at different cell, not certain. May be at cells(2,2), cells(3,10), cells(10,2)............., every time is different. So, I want to get the location of the cell, then set EN is equal to that cell. How to write in marco to get the location of cells. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|