| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
do something to the cell two columns over from curent cell
Hey all. I have a scrap of code that executes when a user doubleclicks
a cell (based on 'Target.Address' thanks to another poster in this forum!). What I need to do is take that cell address and do something two cells over based on it. I cant figure out how to add two cells (or whatever) to the cell address...does this make any sense!?!? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
do something to the cell two columns over from curent cell
You can use Offset
Offset (rows,columns) Target.Offset(5, 1).Value = "H1" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "sumGirl" wrote in message ups.com... Hey all. I have a scrap of code that executes when a user doubleclicks a cell (based on 'Target.Address' thanks to another poster in this forum!). What I need to do is take that cell address and do something two cells over based on it. I cant figure out how to add two cells (or whatever) to the cell address...does this make any sense!?!? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match the Cell From Two Different Columns | New Users to Excel | |||
| get a runing total for"curent date"or(cell)minus prev 30 days( cel | Excel Worksheet Functions | |||
| I have two columns 1 & 0 and want to choose those cell with 1 by . | New Users to Excel | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| every nth cell by columns not rows.... | Excel Worksheet Functions | |||
Linear Mode
