Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight a list
I have a macro that does a nice job of sorting and such. I would like to add
to it a function that would be able to determine all of the rows that has a date entered into column E - and then highlight the row. As all all of the rows with a date are at the top of the spreadsheet after performing the sort, I would hope this would be fairly easy - but not so easy I have figured it out. TIA, Papa J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight a list
Is this helpful?
With Activesheet LastRow = .Cells9.Rows.Count, "E").End(xlUp).Row .Rows(1).Resize(LastRow).Select End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Papa Jonah" wrote in message ... I have a macro that does a nice job of sorting and such. I would like to add to it a function that would be able to determine all of the rows that has a date entered into column E - and then highlight the row. As all all of the rows with a date are at the top of the spreadsheet after performing the sort, I would hope this would be fairly easy - but not so easy I have figured it out. TIA, Papa J |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight a list
Caution:
Bob struck the "9" key versus the "(" key on th first line). "Bob Phillips" wrote: Is this helpful? With Activesheet LastRow = .Cells9.Rows.Count, "E").End(xlUp).Row .Rows(1).Resize(LastRow).Select End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Papa Jonah" wrote in message ... I have a macro that does a nice job of sorting and such. I would like to add to it a function that would be able to determine all of the rows that has a date entered into column E - and then highlight the row. As all all of the rows with a date are at the top of the spreadsheet after performing the sort, I would hope this would be fairly easy - but not so easy I have figured it out. TIA, Papa J |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight a list
Indeed I did, Thanks Jim.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jim May" wrote in message ... Caution: Bob struck the "9" key versus the "(" key on th first line). "Bob Phillips" wrote: Is this helpful? With Activesheet LastRow = .Cells9.Rows.Count, "E").End(xlUp).Row .Rows(1).Resize(LastRow).Select End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Papa Jonah" wrote in message ... I have a macro that does a nice job of sorting and such. I would like to add to it a function that would be able to determine all of the rows that has a date entered into column E - and then highlight the row. As all all of the rows with a date are at the top of the spreadsheet after performing the sort, I would hope this would be fairly easy - but not so easy I have figured it out. TIA, Papa J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Sorted Alphabetical List | Excel Discussion (Misc queries) | |||
highlight lowest value in a list | Excel Discussion (Misc queries) | |||
How do you compare 2 list of numbers and highlight the difference | Excel Programming | |||
How do you compare 2 list of numbers and highlight the difference | Excel Programming | |||
list box item highlight | Excel Programming |