Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having problems with the code below, I just can't seem to get it to work...I tried using range and cell for selection and for the then statement but kept getting errors
Private Sub Worksheet_SelectionChange(ByVal Target As Range Dim selection, val, cel selection = ActiveCell ' should be sheet1 with range e1:e20 the only cells able to cause this to star val = worksheets("sheet2").Range("e13:e200" For Each cell In va If cell = selection The ActiveCell.Activate ' should link to first cell on sheet2 with matching value and highlight the row of this cel worksheets("sheet2").Activat End I Nex End Su Any help would be greatly appreciated Thank Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a click on + symbol to open a root and click on -. | Excel Discussion (Misc queries) | |||
Click on cell to open another workbook | Excel Discussion (Misc queries) | |||
click on cell takes you to specific sheet | Charts and Charting in Excel | |||
how do I format the sheet so that I may click on 1 cell at a time | Excel Worksheet Functions | |||
On click, copy cell contents to another sheet? | Excel Programming |