Highlight noncontiguous ranges of cells

hi, posting example workbook will be helpful

Thanks for the suggestion but the workbook is a company timesheet that I can’t distribute.

as you understand we are not seeking to obtain sensitive company data. You can "desensitize" the data but not change it's type, example: digit replaced with digit, text with any other text etc. The example workbook can have 10-20 rows but then indicate max possible number of rows with data.

Thanks again, I’m not trying to be difficult here and appreciate all the help I have gotten, and I understand that if the workbook contained any relevant information it would be helpful but I’m just working on this, there isn’t anything in the workbook of any value to this question.

All I’m asking is the syntax and methods I might use to say hey take this cell range over here and that cell range over there and set the color to light grey. And to reference noncontiguous ranges by column and row rather than cell say ("F14:F24,F28:F35",F38:F45).

Or a reference to anything similar, I searched the archive but can’t find anything similar.

Thanks again.

Originally Posted by shg

Please Login or Register  to view this content.

Thank you, that’s pretty close to what I need. I have two questions, what would the syntax look like if I wanted to use a variable, column number for the column rather that F:F, and is there somewhere I can look up various acceptable combinations of syntax for the range method so I can learn this a little better?

For example:

Please Login or Register  to view this content.

Originally Posted by shg

Please Login or Register  to view this content.

Thanks again, and I hate to waste your time but I don’t see how that would work using column numbers, I understand the variable as a representation of a text string but I need to provide it a column number.

OK, this is just an example, there will be some other testing going on to determine if the color should be changed or not so this doesn’t make much since but here is the idea.

I simply put the variable Column in your line of code, it’s obviously not correct syntax but hopefully you get what I’m trying to do.

Thanks again

Please Login or Register  to view this content.

Thanks you so very much and sorry it took so long for me to explain what I was after. That is working perfectly. Here is the code as I modified it for my use and a copy of a test workbook.

What do you think of my approach, is there a cleaner/better way? Do I need the entire object description “ActiveWorkbook.ActiveSheet.Cells(3, iCol)”? The code will be run from a button on a sheet but the code will be in a module available for use by 12 sheets.

Please Login or Register  to view this content.