LinkBack URL
About LinkBacks
So far i've got this
Im geting a mismatch error and im not exactly sure why
If ActiveSheet.Range("K5:K500").Value = 1 Then EntireRow.Hidden = True End If
So far i've got this
Im geting a mismatch error and im not exactly sure whyIf ActiveSheet.Range("K5:K500").Value = 1 Then EntireRow.Hidden = True End If
You'll need to apply a loop procedure to evaluate each range separately.
Dim rngCell as Range For Each rngCell in ActiveSheet.Range("K5:K500") If rngCell.Value = 1 Then rngCell.EntireRow.Hidden = True End If Next
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
That did it
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks