Search results for query: *

Skip, PH Yes thanks!! Sorry skip - I think as I posted an error message just you posted a solution. Both solutions worked - PH a[[liced the red background exactly and suspect Skip, yours will be exact (it just included two more cells above row 11 but is pretty much what i spent 3 days trying...

Hi PH, Still didnt quite work - I get an Application Run time error'1004' Application-defined or object-defined error message Not sure what i'm doing wrong.

Thanks for the comments Skip, Andy, PH. My original description wasnt great. ITa s spreasheet with about 16 columns and 6000 rows. but i just want to be able to highlight in red the last column. Also, the spreadsheet gets potentially updated everyday - whcih is why i need the code to...

Thanks very much for coming back to me Skip. However, i only want to highlight the section "bounded" by LastRow and LastCol. When i use what you suggested - it highlights the whole sheet. but i feel i'm closer. It all goes wrong with this line: ActiveSheet.Range(Cells(11, 17), _...

Hello, Your help much appreciated here. I completely stuck (have been for days). I have some code below with:(1) find the last cell in a columnwith data and (2) Attempts having specified the beginning of a range, tries to change the whole range red. Am gutted, cant do it! Any help mcuh...