objinfo

Good morning, I have added a GetUserName function to my spreadsheet which has worked perfectly over the last few months. However, since moving the code from a button to a Yes/No dialogue box on startup, users are receiving a compile error when they open the spreadsheet. Interestingly, it still...

Good morning. I have embedded a macro into Workbook_Open but in doing so I am prompted with 'Else without IF' error. It highlights the 'Else' line but I am unclear what further IF statement is needed? Any advice gratefully received. Private Sub Workbook_Open() Dim FR Dim answer As Integer Dim...

Good morning all. I have a working macro below that filters column E according to the username of a person. I would however like to add a second criteria into the mix that effectively says to filter by column E or F. For example, it may be that my username is in Column F but not E, or vice...