Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am not an Excel VBA expert and have run into a roadblock in attempts to create a VBA script to manipulate data in S/S cells. What I want to do is retrieve the address of the active cell. From that I want to get the row number so that I can go to other cell in that row to read and modify cell values. Reviewing all the Excel classes and help files I couldn't seem to locate a method that returns an object that contains the currently active cell address. Any help would be appreciated. TIA ... Mike |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() -----Original Message----- Hi, I am not an Excel VBA expert and have run into a roadblock in attempts to create a VBA script to manipulate data in S/S cells. What I want to do is retrieve the address of the active cell. From that I want to get the row number so that I can go to other cell in that row to read and modify cell values. Reviewing all the Excel classes and help files I couldn't seem to locate a method that returns an object that contains the currently active cell address. Any help would be appreciated. TIA ... Mike . Hi Mike Use the ActiveCell.Address as: Sub ActiveCellAddress() Dim myCellAddress As String myCellAddress = ActiveCell.Address MsgBox "Active cell address: " & myCellAddress End Sub |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Mike
You can read the row number directly: ActiveCell.Row (Likewise for .Column and .Address) -- HTH. Best wishes Harald Followup to newsgroup only please "bmwmcrider" skrev i melding om... Hi, I am not an Excel VBA expert and have run into a roadblock in attempts to create a VBA script to manipulate data in S/S cells. What I want to do is retrieve the address of the active cell. From that I want to get the row number so that I can go to other cell in that row to read and modify cell values. Reviewing all the Excel classes and help files I couldn't seem to locate a method that returns an object that contains the currently active cell address. Any help would be appreciated. TIA ... Mike |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just to add to the previous answers...
You may also want to take a look at the Offset property. Troy Sub Test1() 'Change the cell 1 column to the right. ActiveCell.Offset(0, 1).Value = 123 'Change the cell 2 columns to the right. ActiveCell.Offset(0, 2) = 456 End Sub "bmwmcrider" wrote in message om... Hi, I am not an Excel VBA expert and have run into a roadblock in attempts to create a VBA script to manipulate data in S/S cells. What I want to do is retrieve the address of the active cell. From that I want to get the row number so that I can go to other cell in that row to read and modify cell values. Reviewing all the Excel classes and help files I couldn't seem to locate a method that returns an object that contains the currently active cell address. Any help would be appreciated. TIA ... Mike |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Gregas, Harald
Thanks for yor help. After going back and studying the properties some more I too eventually figured out how to achieve my objective. I should get a book on writing VBA scripts for Excel rather than rely on the help pages. Any recommendations? Mike (bmwmcrider) wrote in message . com... I am not an Excel VBA expert and have run into a roadblock in attempts to create a VBA script to manipulate data in S/S cells. What I want to do is retrieve the address of the active cell. From that I want to |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is a list of books on Excel.
http://www.contextures.com/xlbooks.html John Walkenbach has written a bunch of books. I'd frequent a bookstore and/or library before I made a decision. HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- I should get a book on writing VBA scripts for Excel rather than rely on the help pages. Any recommendations? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
following the active cell address without recalc | Excel Worksheet Functions | |||
How can I use the active cell address as a value | Excel Discussion (Misc queries) | |||
Get Address of Active Cell | Excel Discussion (Misc queries) | |||
Find address of active cell | Excel Worksheet Functions | |||
How to get the active cell address? | Excel Programming |