mystartcol

Hi, I have a working code as supplied below. It works as it should but now i require it to NOT have any action for column D Other than not having it work for that column then all is fine Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim myStartCol As String Dim myEndCol...

Hi, I am using the code supplied below to highlite columns / rows for easy visual purposes. I am looking at this line of code, Range(Cells(Target.Row, myStartCol), Cells(Target.Row, myEndCol)).Interior.ColorIndex = 8 My request would be to have no affect for column D Currently it works like...

Morning all, Hope you had a good Christmas. Below is a current working code which not only does it high lite the row but also the active cell. I now have a sheet which i would like to use it on BUT i need to also high lite the column as well as the row / active cell. The columns in question...

Evening, I have this code in use, Private Sub Worksheet_Change(ByVal Target As Range) With Target If .Column = 7 Then Exit Sub If .Count = 1 And Not .HasFormula Then Application.EnableEvents = False .Value = UCase(.Value)...

Morning, Maybe you could assist me please. I have the following code supplied below. The code at present works for rows 29 & 30 but im thinking of it also needs to work for rows 4 to 28 but another color. is this possible please & could you advise how / where i need to apply the additional...

I use the following code to high light rows & active cells etc. My range is A-G & currently row`s 3-28 How can this code be altered so if the row 29 or 30 is selected then the Interior cell color & active cell turn Red Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim...

Morning all, I have the below working code which highlights a certain selection of cells for easier viewing. My request please is that i also need the same to happen but for another range in the same worksheet. Please could you advise an edit/fix so this is possible for me. It will be the...

Morning, I am using the code shown below so when i open its worksheet it automatically selects the first cell in the last row which has data on. This has worked good for me but now i wish to alter it & asking for advice please. Say the last row with data on is Row 400 & currently when i come to...

Morning, On my worksheet i use the following codes which,highlight the row that i am on,change the text to CAPITALS & also a button to insert a new row. When i insert a new row i get a Run time error 13,type mismatch. When i click on debug i see this line shown in yellow .Value = UCase(.Value)...