Question about private subs
Ok thanks.
"OssieMac" wrote:
Hi again Mary-Lou,
I just did a test with the following code in a sub as follows:-
Private Sub Worksheet_Change(ByVal Target As Range)
'Called from change in Sheet1
Sheets("Sheet2").Select
'The following row fails even though the worksheet is selected
'However, it works fine in a normal module.
Rows("3:5").Delete
ActiveSheet.Rows("3:5").Delete 'This works
'This is the preferred method without selecting the worksheet
Sheets("Sheet2").Rows("3:5").Delete
Regards,
OssieMac
"MLK" wrote:
I have worksheet that I want to trigger a macro when a user selects a value
from a pivot table.
For the most part, the macro works fine except I also want to delete a range
of rows within a different tab in the workbook, but in the macro when I
switch to the other tab and set the range to delete, I get a "Run-time error
1004 - Application defined or object defined error".
Am I not able to access another tab from private sub?
Any help would be greatly appreciated.
Thanks, Mary-Lou
|