Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value of the active cell
Is there a function that would allow me to get the value of the active cell?
like it is done in VBA: Activecell.value thanks -- caroline |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value of the active cell
Not a function, worksheet functions do not know what the active cell is, you
need event code for this 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Me.Range("H10").Value = ActiveCell.Value End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "caroline" wrote in message ... Is there a function that would allow me to get the value of the active cell? like it is done in VBA: Activecell.value thanks -- caroline |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
value of the active cell
Thanks That is what I thought.
-- caroline "Bob Phillips" wrote: Not a function, worksheet functions do not know what the active cell is, you need event code for this 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Me.Range("H10").Value = ActiveCell.Value End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "caroline" wrote in message ... Is there a function that would allow me to get the value of the active cell? like it is done in VBA: Activecell.value thanks -- caroline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How do I have an active cell highlight automatically | Excel Discussion (Misc queries) | |||
Highlight Active Cell...With a Diffrence | Excel Discussion (Misc queries) |