Search results

Now I don't expect many (any lol) of you to actually like this song as it's pretty strange (check the lyrics if you want a chuckle) and aggressive, but the drumming in it is just mind blowing so thought I'd share anyway. Since there is no decent footage of the actual Tool drummer performing...

28, 58

Ah the dreaded auto-start feature. About as helpful as the 'I'm putting MS Edge on your taskbar whether you like it or not' feature..

Yip so have changed the default and that seems to have done the trick. Seems to be a 'feature' of this program that after a PC re-start, it always opens on the default monitor regardless of where it was last closed. Cheers CJ

Yeah unfortunately monitor 1 is 43" and the other one is 24"

Sorry I guess I meant 'make it smaller' when I said minimize. So it does retain that info but only until the PC is restarted.

My low level annoying problem is that every morning when I log onto my PC, all of my apps that I open, open on the monitor that they were closed from on the previous day. Except for MS Teams. Every day it opens fully maximized on monitor 1 and I have to drag it over to monitor 2 and minimize...

Kind of has it in the title though to be fair ;)

Wonder no more ;)

Argh so many favourites... "I don't blame you for taking umbrage with animals staring at your cleavage" - Lou Reed, So Alone "If the real Jesus Christ were to stand up today, he'd be gunned down cold by the C.I.A." - The The, Armageddon Days (Are Here Again) "Cold silence has a tendency to...

Well I was only trying to show a method of finding the row that he was after, not trying to write his code for him.. But thanks for the feedback, I'll be more careful in future never to suggest anything. (y)

Does this help..? Dim rRange As Range Set rRange = xlSh.Cells.Find(What:=rsLeave![DoD ID], After:=ActiveCell, LookIn:= _ xlFormulas2, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _ xlNext, MatchCase:=False, SearchFormat:=False) rownum = rRange.Row

Since we've been talking about drumming...

Cool - I didn't even know this was a real person, I just hear it a lot when my mate from England says he is hungry

David Lifton Best Evidence: Disguise and Deception in the Assassination of John F. Kennedy

Like Bruce Dickenson, the lead singer from Iron Maiden - flying the band on tour in their own Boeing 747!!

On your Sheet3 code, I think this bit should have been If ActiveCell.Text = "DELETE" Then

Yeah I thought it was an odd way of doing it but his original request was to populate multiple sheets (1 sheet per year) and so I thought he was still going down that route. This request is a bit of a moving target to be fair...

OK looks you have decided to create the Workbook from scratch when the report is run. You will probably need to work out how many sheets to create based on the range of leave in your table, but I'm sure you can work that out. Gasman is right in that you are referencing the wrong object, this...

Try something like this.. Sub Macro1() Dim i As Integer Dim y As Integer With ThisWorkbook.Sheets("Sheet5") .Range("D3") = "Monday" .Range("D3").AutoFill Destination:=.Range("D3:ND3"), Type:=xlFillDefault y = 4 i = 1 Do Until .Cells(2, y).Address = "$NE$2"...