View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mariusfink@googlemail.com is offline
external usenet poster
 
Posts: 3
Default Event Programming - Cell Value change - 2 sheets involved - VBA - Excel

Hi,

I got an excel file consisting of 3 sheets.

I want to hide rows 53 to 88 in the last sheet called "Expense Report"
whenever there is a value (letters) entered in cell C6 in the sheet
"General Info".

I know I need a Worksheet_SelectionChange event and this is what I
came up with. However it does not work. This is what I programmed:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheets("General Info").Select
APPILCATION.Goto C6
If (ActiveCell.Value 0) Then
Sheets("Expense Report").Select
Range("53:88").EntireRow.Hidden = True
Else
Range("53:88").EntireRow.Hidden = FALSE
End If
End Sub

Any help?

Where do I need to put the code when I open the VBA-editor?

Regards