PDA

View Full Version : VBA macro for highlighting datain range based on selecting data in another



estatefinds
04-14-2016, 08:32 AM
Hello, I need macro in which I select on the data in Column AX so for example only: the data is
7-9-13-19-33 in which I select with cursor when I do this each number of this data or five number combination will be highlighted yellow in the uncolored remaining data in the columns BB to BF. see example.
Also, as I select each piece of data in Column AX and the further I go down the worksheet the data in the BB to BF will be out of sight.
is there a way as I go down the data in column AX to keep the Data in columns BB to BF in view?

estatefinds
04-15-2016, 05:06 AM
I appreciate any help with this, Thank you