Replies

Hans (and Jerry!)

Thank you for your comprehensive reply on this issue. The workbook and worksheets perform as you have briefed.

Big thank you:-)

Hans,

Thank you for that. Works as advertised.

Jerry,

I get a “Compile error: Syntax Error. and the line of code starting: Cells.find.. is in red. Am not able to troubleshoot as I haven’t a clue what to do!

Problem now solved, so thanks to both of you.

Thank you both for your swift replies. Visitors have arrived at 2100 (local) so I will test tomorrow.

Why is it wife’s won’t let you play on computers when you have visitors?

Rory

The deed is done. Everything still works.

The top line of the ZA entries, specifically, 192.168.1.64, I cannot change, as it is always in use. I cannot delete it as it says ” You cannot delete an active subnet”.

I assume that the entries for the Internet zone, which is the name of each wireless adaptor, was required to access the internet.

Rather than divert your talents this way for any longer, shall we call it a day? I have included a screen grab of laptop 3’s ZA settings that detail your suggested subnet settings.

Now I’m confused… I have set the adaptor (.64) to the trusted zone, and I still have Internet access. I swear it didn’t do that before.

Rory, knock it on the head, mate, I’ll get back to you. Thank you for your thoughts and advice.

Rory

The .64 entry is the address that appeared when I switched it on (the wireless connection, that is). All 3 laptops have their address at the top of the list in ZA. The .79 laptop has stayed on .79 when I switched on this morning. (How did that happen ?)

I used a subnet of.80 as it was an address that hadn’t been used previously (sorry, Rory, just my twisted thinking!)

When I was setting up everything initially, I couldn’t see the 2 other laptops from my main laptop, so I used the IP addresses that were displayed in ZA and set up each laptop with the addresses of the other 2 and it all worked. (apart from the snag of the increasing IP address). ZA version is 6.1.737.000.

I’ll set 192.168.1.0 etc and get back to you shortly.

Rory

All laptops now on a subnet. All seeing each other and accessing the internet. The ‘rogue’ laptop with the increasing IP address has been booted twice and the numbers have stayed the same (192.168.1.79). The main laptop still takes several minutes to see the other 2 before showing shared network files and will hang if I access a shared folder and then try to ‘back to’. But as that wasn’t in the opening query, it doesn’t need a reply!!!

I do have other questions regarding IP addressing settings with the laptops, but I think I’ll leave it for now. I have included a firewall pic of what is on laptop 3 FWIW. Despite what you may think, learning has taken place at this end!

Thank you.

Rory

The router is enabled as a Local DHCP server, with a starting address of 192.168.1.64. The .64 is changeable. There is a box with ‘Maximum number of DHCP users’ filled in with the number ‘191’, which is also changeable. There is an IP of 192.168.1.1 for the router and a subnet mask of 255.255.255.0

The IP addresses of 2 of the laptops, .64 and .66 appeared when I switched them on with the router powered on and have stayed the same since. The laptop with the increasing numbers is obviously going to stop at some stage! Below is a cut and paste of the router status page.

IP Address: 192.168.1.1
Subnet Mask: 255.255.255.0
DHCP Server: Enable
Start IP Address: 192.168.1.64
End IP Address: 192.168.1.254

HTH, thanks.

Wide image cropped by HansV

Rory

Thanks for the swift reply. I am unsure on the subnet issue. I have included a jpg of the computer firewall settings on the laptop that increases its IP address by 1 or 2 numbers each time for clarity.

Do you mean add an IP address as a subnet on the main laptop, and then enter the same address on the other 2? Sorry to be a dullard

Might be worth borrowing a USB adaptor to try the system out and see how you get on. To buy, they are about

Zave

I have a Dell 510m laptop and was unable to access my wireless network. So I disabled the 2100 3A mini PCI adaptor and bought a gigabyte usb wireless adaptor and tried that. Didn’t work every time as the connection of the USB was not a tight fit. Solved that with an extension cable. Snagless ever since!

HTH

Jezza,
That works for finding the last populated cell in the column, which for column A, was 31-12-05 and for column B was 0:00 which is a time cell in the format [h]:mm. I was looking for the last entry in B and the date in A which corresponded. But thanks for taking the time and showing us all an interesting formula.

Mbarron,
I have puzzled over this one, and have not grasped the way it works; (then again, grasped never was my strong point!) but, thank you for taking the time to reply and your knowledge.

Hans,
That’s the one! It worked! Just made the A column ref absolute and it does what it says on the tin. (AKA WOPR).

Many thanks everyone.

Hans

I went back 2 months in addition to the 12 months to test for other conditions in the sheet. I can send the sheet if you are curious.

Now to work on the suggestions!!!

Hans,

That’s exactly what I want to do! As you have pointed out, it was the full field name that was missing. Doh!

Thank you very much!

Best wishes

Farside

Hello, Hans

I have enclosed an example for clarity. I have tried various combinations of reference but am struggling. I feel as if it’s almost there and that I must be missing something obvious.

Best regards,
Farside

Hans / Jerry

Despite having a large book with 700 pages of formulas and a long time in which to read it; it was down to the users of Woody’s Lounge to provide the goods.

Thank you, I can now comprehend