sgmpatnaik
Board Regular
- Joined
- Jul 6, 2012
- Messages
- 75
Hello Sir,
I have created a code to update the data from One Sheet to Another Sheet that code works perfect but there is one problem i am facing that i tried to hide the certain range of rows in that sheet so i searched in Google and i got a example code. With That Example Code i did some modification as per my requirements but now there is one problem that is i want to change the range of the code but i can't when ever i run the code after change the range then i am getting the error msg as Type Miss Match. for your knowledge i am mention the code below please have look and kindly give the step by step instruction.
When Ever i want to change the Range then i am getting the error, but when i put the same range then i am not getting any error msg and code works fine
Your Replay is Highly Appreciate
Thanking You
I have created a code to update the data from One Sheet to Another Sheet that code works perfect but there is one problem i am facing that i tried to hide the certain range of rows in that sheet so i searched in Google and i got a example code. With That Example Code i did some modification as per my requirements but now there is one problem that is i want to change the range of the code but i can't when ever i run the code after change the range then i am getting the error msg as Type Miss Match. for your knowledge i am mention the code below please have look and kindly give the step by step instruction.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Call UnprotectSheets
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
If Not Application.Intersect(Range("E9:E52"), Target) Is Nothing Then
Rows(Target.Row + 1).Hidden = Target.Value <= 0
End If
Sheets("Purchase").PivotTables("PivotTable2").PivotCache.Refresh
Range("b:b").ColumnWidth = 27
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
Call ProtectSheets
End Sub
When Ever i want to change the Range then i am getting the error, but when i put the same range then i am not getting any error msg and code works fine
Your Replay is Highly Appreciate
Thanking You
Last edited: