Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy an offset value when select
Dear all,
I have a sheet content a column cusip and a column proceed amount. I want to know how to write a VBA when I right click cusip cell and it will auto copy the offset cell, assume 2 column right beside it, value. I want to combine this 2 movement in one VBA, if any one know how to. I have a Bloomberg VBA will execute when I first right click cusip cell: Sub CPD() BBfunction = "CPD" Call bbfunctioncall(BBfunction) End Sub If anyone have idea, please give me a hint, thanks a lot. Vincent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what does target.offset(0,-1).select mean here? | Excel Programming | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
Help in using an Offset in a .Range().Select | Excel Programming | |||
Select row (with offset) from VB formula result | Excel Programming | |||
Select and Copy Range using Offset | Excel Programming |