Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm kinda new to excel vba. I'm trying to make excel
launch a sub when a cell i a range is changed. code as of now: Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'StrOmraarde$ = "e16:e1000" Adresse$ = "$E$25,$E$40" If Target.Count 1 Then Exit Sub If Target.Address = "$F$25" Then MsgBox ("test1") Else MsgBox ("test2") End If End Sub This works fine, but I need address to be a range ie. "E16,E55". How do I do that?? Thanks Lars Kofod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |