Forum

Hi Brian Nice to know the formula is working for you. LOOKUP (or VLOOKUP/HLOOKUP with the last argument TRUE/1/blank) does an approximate search...

Hi Brian LOOKUP requires the lookup vector (e.g. G2:L2) to be sorted in ascending order (which you can't do in your example), otherwise it may give...

Hi Nikki Welcome to the forum. Give this a try. Sunny

You can try this to get the user name Sub DeletePlayList() MyName=environ("username") On Error Resume Next Kill "C:Users" & MyName & ...

Hi Julie It would help if you can post a file with some sample data. It will help others to understand your needs better.

You can try this code to delete the files. Sub DeletePlayList() On Error Resume Next Kill "C:UsersUserNameMusicPlaylistsMyPlayList*.wpl" On Error G...

Hmm didn't know about the limit. I would have deleted the old playlist (if one exist) before I play a new video.

Hi Victor I have tested it on Excel 2013 (64-bit) and did not encounter any problem. I really have no idea what is causing your error. Sunny

Hi Victor I have tested the codes on my personal PC and at the workplace with no problem whatsoever. Possibly Excel version problem (I am using ...

Hi Victor Thanks for your feedback. Good to know the codes are useful to you. Cheers Sunny

You can also refer here for another topic on WMP.

Hi Victor Give this a try. You will need to adjust the codes to suit your needs. Hope this helps. Sunny

Hi Stee I don't see any reason why the list or combo box is unable to pull the data from the hidden tabs. You did not specify whether the list/c...

Hi Kris Try this =IF(AND(D2<>"",G2<>""),"Completed","Outstanding") You only placed one of the parentheses in the wrong place S...

Hi Yunus In your formula VLOOKUP($C7,'Sales Tab'!$F:$CF,'Sales Tab'!AW$7,0), you will need to check what is in cell AW7 It should contain the co...