WiresAnSteel's channel

WiresAnSteel commented 1 year ago

1:47 Add to

JF4220031 shunt to shed

A short clip of JF4220031 at Hayes Knoll. Having been detached from it's freight train, the loco runs forward and reverses into the platform road. ...

275 views

WiresAnSteel said:

Hi, that's a really nicely presented 0-4-0. We have just aquired a couple of scruffy ones and are looking for inspiration to get them up to scratch. Please may I use your clip in one of our own please or anything 0-4-0 diesel, i.e restoratin?

• 9:39 Add to

  Swindon & Cricklade Railway - End-To-End Celebration 25/07/10 Part 3 HD

  A visit to the Swindon & Cricklade Railway during their 'End-To-End Celebration' held over two Sundays 18th July & 25th July. This event saw trains...

  327 views

  WiresAnSteel said:

  Hi. This is great.

  Could I use your clip in one of my own? Our village has just refurbished a derelict railway station, we have a couple of diesel shunters and your footage would be inspiring..

• 3:06 Add to

  Ruston Cold Start at Decauville Spoorweg Museum Holland

  Starting up our Ruston 20DL 296111 of 1950 after the winter season

  Allso see:

  http://nmld.locaalspoor.nl/...

  24,933 views

  WiresAnSteel said:

  Phew! - I've done that a few times with tractors and statinary engines.

  You kinda get to know the swing and it's not so much brute force,( only at first when you're getting used to a different machine). Some of them kick back nasty andcan hurt. That's usually when the starting handle is used on...

• 3:47 Add to

  Shannon - Let The Music Play (original video)

  The first freestyle record in history

  766,119 views

  WiresAnSteel said:

  Rarrr! Iconic tune, untouchable. Been resampled in a chart tune recently, but doesn't scratch the surface of this original. It's Never worked massively in discos, dunno why.

• 2:27 Add to

  The Police "Canary in a coal mine"

  53,489 views

  WiresAnSteel said:

  massively understated tune, dunno why it didn't chart at the time.

+ 4 more videosshow less

WiresAnSteel commented 1 year ago

13:27 Add to

Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?

See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA cod...

10,108 views

WiresAnSteel said:

Phew! lost me there. Great to see two giants of Xcel/VBA together in one clip.

Great job guys!

I used to be OK with basic and could dimension arrays,nest loops, call subs on variables etc but VBA is really challenging me now. Don't know yet what commands will follow each other and getting lots ...

• WiresAnSteel liked 1 year ago

+ One more: Likedshow less

WiresAnSteel commented 1 year ago

2:10 Add to

Excel Name Trick #2: Names for Go To Quick Navigation

See how to use Names cells to navigate quickly for one location to another in a workbook.

This is a logical (beginning to end) story about most of...

6,830 views

WiresAnSteel said:

Great explanation.

Any ideas how to relative name a single cell in VBA that doesnt try to reference the original sheet it was created in please?

• WiresAnSteel liked 1 year ago

+ One more: Likedshow less

WiresAnSteel commented 1 year ago

4:12 Add to

Excel VBA 1 - Never AutoSum

When you are recording a macro, never use the AutoSum button. This video will show you the workaround to summing a column in a macro.

1,831 views

WiresAnSteel said:

Excellent. This comes at just the right time as I am having problems with autosumming just as you point out in this clip. I'm looking forward to trying this out..

The big M? tsk, pfffft!

Never didunderstand corporations shunning Lotus.

• WiresAnSteel liked 1 year ago

+ One more: Likedshow less

WiresAnSteel commented 1 year ago

9:45 Add to

Excel Macro VBA Tip 24 - Learn The For Next Loop For Excel Macros

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial shows you how to create ...

10,369 views

WiresAnSteel said:

Neatly explained thx

• WiresAnSteel liked 1 year ago

+ One more: Likedshow less

WiresAnSteel commented 1 year ago

9:45 Add to

Excel Macro VBA Tip 16 - Using Offset in Excel Macros and VBA

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Use the Offset property in Excel Macros. This tut...

8,559 views

WiresAnSteel said:

Very clear, Thx, nice example using colour blocks for destinations (keeping number-clutter out for a change).

Gonna subscribe.

• WiresAnSteel liked 1 year ago

+ One more: Likedshow less

WiresAnSteel commented 1 year ago

5:51 Add to

2.26 Password Login Form / screen using VBA in Access

Creating a Login Form and password protecting your database

Here's the code I used:

Username.SetFocus

If Username = "user1" And Password = "user1...

99,205 views

WiresAnSteel said:

Hey da iawn ti Diolch

-good job, thx for explainin so simply.

• WiresAnSteel liked 1 year ago

+ One more: Likedshow less

WiresAnSteel commented 1 year ago

10:59 Add to

Excel VBA Intermediate Tutorial - Referencing Cells

This tutorial goes through various ways of referencing cells using VBA code. For more tutorials check out http://www.vba4excel.com

26,229 views

WiresAnSteel said:

Been looking for this info for days, didn't know what to type into google to find It. Could have done with a relative cell ref to here hahaa :)

Seriously though, thanks for taking the time to post.

• 2:40 Add to

  Caffi'r Bae / Bay Cafe, Benllech, Ynys Môn Anglesey

  Please call 01248 852700 to book a table. You can also e-mail us on baycafe.caffirbae@yahoo.com

  1,459 views

  WiresAnSteel said:

  Yum yum, well, we've just got back from Caffi'r Bae and we're very pleased we went. We will definately be going again! Super warm welcome from a family run business. Phew we're full-up! couldn't handle a sweet this time but we did have a starter as well as main course. See you again folks. Diolch...

• 2:05 Add to

  Matt's customized Kayak

  Matt picked up a used Kayak and customizes it for his camping trip. He expanded the middle hole and added two hatches for camp gears. I am impres...

  9,523 views

  WiresAnSteel said:

  How did you get on with this? I am just about to do the same with a similar kayak, and change the keel shape so it tracks nicer.

+ 2 more videosshow less

WiresAnSteel commented 1 year ago

8:21 Add to

A Copper Mine Adventure

Visit a copper mine in mid-Wales and uncover some of it's secrets

821 views

WiresAnSteel said:

Excellent stuff, bare bones of a rockin' geology documentary. Enjoyed the adventure aspect too.

Aww, wanna go ther now darnit! Oh, and that other place, and the cool place where....

• 7:36 Add to

  Parys Mountain

  Take a trip around Parys mountain and discover the hidden history of the dwarven mining empire

  1,534 views

  WiresAnSteel said:

  Delightfully OTT, but some spectacular & intersting shots to boot. Loved it.

  err... is Woman married?

+ One more videoshow less