Dr Sheldon Cooper

Hello

I some VB code written in Excel 2003 that no longer works in Excel 2013:

With Application.Filesearch

.SearchSubFolders = False

.Filetype = msoFileTypeExcelWorkbooks

.Lookin = sMonPath

After some googling (or Yahooing in this case) it seems that .Filesearch no longer exists in the latest versions of Excel and I need to use something about 'Dir' instead but I have no idea how to make this happen.

Can anyone help me?

Help! I am using Excel 2003 but have a colleague using Excel 2013 at the other end of the country (so I can't go and see them!). I need to show them how to change the 'Edit - Links - Update - Automatic' setting that is in Excel 2003, but I don't know where it is in Excel 2013. Any ideas?

I have two groups of radio buttons on a spreadsheet.

One group hides/unhides various rows, the other hides/unhides various columns.

I want a radio button/dot to appear once in each group but at the moment they only get one dot to share between them.

Any ideas?

Similar to the main three wing chun forms where you don't stomp around too much, any style would be fine and video links gain you extra points.

I'd be much obliged if we could avoid the usual soapbox replies about needing to go to a class, not learning from words and pictures etc, ta!

I am running a spreadsheet in excel 97 that has mysteriously begun to lock cells that data is pasted into. There is no VB code running that would do this, does anyone know if there is a setting that might need to be changed?

anything else to look for when buying this model would be handy too. thanks

Thought it might be the civil wars but i cant find it anywhere

It was an early 90's sf2 style arcade machine and the only character i can remember was a sort of Chinese mandarin wizard/zombie with purple robes who could throw magic, float and do a double footed kick. Any ideas? Thanks

Its an r reg 1l corsa ls. There us intermittent squealing, dimming headlights/electrics and rough idling and general chugging so im thinking a new alternator and am looking for a ballpark cost

It is an r reg 3 cylinder 1l ls. There is a half inch rubber belt on the drivers side of the engine running round two big wheels at the top and bottom and a smaller one half way down, is this it or is that the fanbelt? Cheers.

It is a 98 1litre corsa, says 'LS' on the side and 'merit' on the v5 and 12V on the back. The engine doesn't have regular ht leads, instead there is a long plastic strip with one cable. I can't tell from the manual and i need to know what sort of redex to put in

My 98R reg corsa merit 12v 1litre seems a bit reluctant to start sometimes. Key turns etc but engine slows and stops. A few revs on the peddle seems to get it going and sometimes its fine. Any ideas?

my wife's netbook has packed up.

i want to try to start it in safe mode but there are no 'f' keys to do f8.

when you switch it on there are options to press 2 for setup or 0 for boot options but i cant find a safe mode option.

there is no cd drive to boot from a disk.

any ideas?

so i've been doing choi kwang do for a few months.

the good stuff: they're all friendly, the chief instructor at the club is excellent, knows his stuff, isnt afraid to demonstrate, explain and answer questions.

the bad stuff: i'm not finding it very challenging, the gradings are expensive (the lessons are reasonable though) and the assistant instructors are rubbish and the sparring is non contact

think i've just answered my own question; go!

anyway, consider this your opportunity to vent your spleen at/sing the praises of ckd as appropriate. most entertaining and ckd topical gets best answer!

he's all over youtube, runs a pretty big organisation and seems to be pretty well trained. anybody know who/where/what his training is etc, how old he is and anything else about him? cheers

please dont quote anything from wikipedia, ive already looked there!

thought about it the other day, i've trawled all my regular combat sports sources and drawn a blank, any ideas?

i want a new phone. it needs to play youtube videos and upload photos to ebay. my old phone was a vodafone 725 which did the youtube bit but you cant get them anymore. i would like one as cheap as possible on pay as you go, i dont do contracts and im not fashion concious. any ideas? thanks

this is for the new 'armies on parade' competition. i'm using river trolls with chaos giant heads for great unclean ones and am considering ghouls or plague monks as starting points for plague bearers. what's giving me the most hassle is plaguebearer heads and nurglings so any ideas greatfully received, cheers