grid me

[Trevor3007]

Hi,

I am on a works rota & would like to run VB so each month when the rota comes out , I can place a 'grid' (double outside / thick line & line colour red) it will find my name and do this for me. The reason it must use me name , is becasue it depends of the number of other staff who are on the list too ( for example, july 22, I am in row 14, but in august22 I am now in row 35)
22
All the names start in col E:EJ.

I hope this maked sense...thank you

 

[Logit]

Ok .... ran into a "Subscript Out of Range" error.

Ran an "F8" check and discovered the following code line :

' XXX Changed to xlPart was xlWhole
    Set rngFound = rng.Columns(1).Find(What:=findName, After:=rng.Cells(1, 1), LookIn:=xlFormulas2, _
                        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
                        MatchCase:=False, SearchFormat:=False)

.... has an undocumented VBA term "xlFormulas2" which began with Excel 2016. For pre-2016, if that term
is changed to xlFormulas the macro runs as intended.

Thank you for providing the file.

 

[Trevor3007]

HI Logit,

sorry , but am supposed to do any thing?

 

[Fluff]

has an undocumented VBA term "xlFormulas2" which began with Excel 2016.

It actually started with 365 & I suspect only exists in 365 & 2021

 

[Trevor3007]

Hi Fluff,

I changed to from xlFormulas2 to xlFormulas & it still works OK :}