how to change highlighted rows back to original colour

**cfinch100** · 05-20-2013, 04:26 PM

hi
i have code for worksheet that highlights rows in orange manually,the code did collumns and rows which ive changed,i want to use as a visual stock take,ie go down sheet1 and mark all orange,what is not orange is not there ect,you just click on row in sheet1,code is in the tab,my problem is when stock take over i need to undo highlighting but leave data there ,not delete rows as in many threads',i tried changing no 49407 to 2 which is supposed to be white but came out black

Please Login or Register  to view this content.

has any one got any pointers please
cheers colin

**JieJenn** · 05-20-2013, 04:34 PM

try Selection.Interior.Pattern = xlNone

**cfinch100** · 05-20-2013, 04:51 PM

hi
where would this go in code
cheers colin

**JieJenn** · 05-20-2013, 06:43 PM

What are you trying to do again? Easier to hep you if you post a sample workbook.

**cfinch100** · 05-21-2013, 02:29 AM

hi
have posted log,its sheet1 have adjusted code to make highlight (orange)stay on sheet and so you can select multiples but how would you change colour to white to unhighlight some of them,its a stock take,will highlight all items we have then enter barcode number,then deselect them all and the ones without barcodes change to different colour to tell visually what has not been seen
cheers colin