Private Sub Workbook_SheetSelectionChange( _ ByVal Sh As Object, ByVal Target As Range) With ThisWorkbook.Names("ACTIVECELLADDRESS") .Name = "ACTIVECELLADDRESS" .RefersToR1C1 = "= Address (" & ActiveCell.Row & "," & ActiveCell.Column & ")" End With
I am a daily currency trader, what I want do is find a excel formula that when I enter the date for that day of trading that it will keep a running total of the percentage +/- made with each trade I open and close for that day only to reset it self when I enter a new date.
Currently I enter a date in a cell in column "J" of each row for each trade, I can have as many as 20 trades a day, my last column "W" records the percentage made +/-.
Robert thanks for your lesson its quite clear . But i have a problem with merge cell (two cell combine into 1 cell) when i use the filter and filter the typical name of client but the filter only show the single cell data but not the merge cell data. i,e client A - do the action 1 and 2 so i combine the action together and put the client name so that i can see this one person do the double action. But i wan to print out the combination of the actions but filter only show one cell action. How??
Thanks so much. It pecked my brain at first, but now I feel 1000 times smarter!
cierramiss 1 week ago
Thanks Robert
could u help me what's wrong in below code
Private Sub Workbook_SheetSelectionChange( _ ByVal Sh As Object, ByVal Target As Range) With ThisWorkbook.Names("ACTIVECELLADDRESS") .Name = "ACTIVECELLADDRESS" .RefersToR1C1 = "= Address (" & ActiveCell.Row & "," & ActiveCell.Column & ")" End With
it's not work
thanks
Asoor2 1 month ago in playlist Excel
Robert, thank you for the lesson, it was very clear and concise. Thank you for taking the time to share your knowledge..
herglgl1st 1 month ago
Thank Very Much this is a great function...:)
xntive1 4 months ago
Hi
Thanks for this great video.
can u tell me plaese, why its highlight only in cell "A1" in my workbook?
Regards
Rafi
rafiesh1 4 months ago
How do you make it work in Excel 2010?
123789s1 5 months ago
Doesn't work in 2010.
123789s1 5 months ago
Robert, help!
I am a daily currency trader, what I want do is find a excel formula that when I enter the date for that day of trading that it will keep a running total of the percentage +/- made with each trade I open and close for that day only to reset it self when I enter a new date.
Currently I enter a date in a cell in column "J" of each row for each trade, I can have as many as 20 trades a day, my last column "W" records the percentage made +/-.
2009jaxs 1 year ago
Robert thanks for your lesson its quite clear . But i have a problem with merge cell (two cell combine into 1 cell) when i use the filter and filter the typical name of client but the filter only show the single cell data but not the merge cell data. i,e client A - do the action 1 and 2 so i combine the action together and put the client name so that i can see this one person do the double action. But i wan to print out the combination of the actions but filter only show one cell action. How??
smarkliang1 1 year ago