Hi all.
I think the title of this thread says it all. I'm still new enough to vba that I'm understand that there are different methods to search spreadsheet data and or ranges, but I'm not sure what the fastest method is to search through named ranges in sheets.
In "sheet1", I have a range of times that are next to to-do items in a list (scheduled times to perform tasks).
Those time entry cells have cell validation for a drop down list of times, referencing the "hourlyTimes" named range from "sheet2", which contains all named ranges used for various drop down lists in the workbook. The time entry cells are in Column "O", for reference in the code below.
That "hourlyTimes" named range already has conditional formatting applied to each and every time listed in the range, shading or coloring the cell backgrounds with a color suggesting the color of the daylight based on time of day, and dynamic based upon known sunrise and sunset time variables specified elsewhere. This is a kind of color coding template that I can change in the sheet without entering the VBA editor, styling time of day colors if needed to be harmonious with a potentially changing color palette template for the whole workbook.
Now I need to take my time entry cells in the to-do list in "sheet1" and lookup their corresponding values in "hourlyTimes", and inherit the interior color from the corresponding address/position from "hourlyTimes".
I presume my code would look like this, with the ask or question from the community here being to fill in the fastest method to accomplish this where my code reads ????
Attached is a jpeg with screen shot crops from sheet 1 and sheet 2, hopefully ; ) for clarity.
Thanks for any help in advance all, much appreciated!
Frank
Bookmarks