Multiple "ByVal Target As Range"

**batchy** · 11-08-2013, 12:36 PM

Hi,

I have a worksheet which has 2 fields (cells). When these values change i would like my VB code to hide a range of cells.

The 1st code works fine:

Please Login or Register  to view this content.

However when i add in the 2nd range it fails and not sure why?

Please Login or Register  to view this content.

**judgeh59** · 11-08-2013, 01:43 PM

From what I know WorksheetChange2 won't work....the system work recongize the "2"....but you can put the code from "2" into first one and it should work because you are looking at different cells....I think that should work....HTH

**batchy** · 11-08-2013, 02:04 PM

I have tried changing the name but still not working :s

**batchy** · 11-08-2013, 02:06 PM

Please Login or Register  to view this content.

i have tried putting the code in the same SUB but still not working

**judgeh59** · 11-08-2013, 02:09 PM

try this

Please Login or Register  to view this content.

**batchy** · 11-08-2013, 02:38 PM

I received an error

Compile error:

Block If without End If

**judgeh59** · 11-08-2013, 02:39 PM

Please Login or Register  to view this content.

**batchy** · 11-08-2013, 02:48 PM

Excellent many thanks what was the difference?

**judgeh59** · 11-08-2013, 02:50 PM

if the first attempt when you combined the two subs you put one IF statement inside the other....when I copied and seperated the two, I left out the last End IF...glad I could help....and thanks for the +rep

Multiple "ByVal Target As Range"

LinkBack

Thread Tools

Rate This Thread

Display

Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Re: Multiple "ByVal Target As Range"

Thread Information

Users Browsing this Thread

Similar Threads

Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Range)<"

Need help creating VBA looping code in "Worksheet_Change(ByVal Target As Range)"

[SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?

Worksheet_CHange (ByVal Target as Range) when target is formula cell

2 target cells for "Change(ByVal..." worksheet macro

Bookmarks

Bookmarks

Posting Permissions