| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign values to a cell in sheet A, from worksheet_change event of sheet B
Hi All,
I have this function in sheetA of my workbook, the event triggers but i get an "Application-defined or object-defined error". Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Row = 1 And Target.Column = 1 Then ThisWorkbook.Worksheets("sheetB").Cells(1, 10).value = "100" End If End Sub I tried searching on knowledge base and google it but didnt find any specific explanation. I also tried selecting the worksheet, by using this code but that didnt help either: ThisWorkbook.Worksheets(Sheet).Select Any tips/suggestions are highly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
| Copying values from one sheet to the same cell in another sheet | Excel Discussion (Misc queries) | |||
| Clearing Cell Contents / Worksheet_Change Event | Excel Worksheet Functions | |||
| assign values to specific cells in an excel sheet through text file | Excel Discussion (Misc queries) | |||
| Lookup numbers in sheet and assign it's cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
