exceldum

Looking to hang 50 computer off of the lan side. Currently have a 851 cisco taking care of 41 computers with no problems, but I know it should not be taking care of that number of machines.

How many computers can a Cisco 851 router support? Have a network that consists of a 851 Cisco with 2 48 port switches behind it. Currently there are 30+ workstations that access the network and internet daily through the 851 with no issues, but plan on adding another additional 15 computers in the near future, should the 851 be able to handle it or should I look into getting something with a little more memory/processing power?

I have an excel sheet that I have several users enter data in, and a good portion of the time they do not fill in cells that NEED to contain data. It will be all numbers. Basically what I need it to make lets say column E, all cells need to have data in them, or it will prompt user when saving the document that they need to enter data in there to be able to save it. If you need more clarification let me know.

Currently I have it half working, but it clears my formula.

Sub Clear_Ranges()

Dim rng As Range

Set rng = Range("A4:E4, A9:E9")

For Each cell In rng

cell.Value = 0

cell.NumberFormat = "$#,##0.00"

Next

End Sub

Want to clear the text or data that is entered in to A4,B4,C4,D4,E4 and A9,B9,C9,D9,E9 with a button. With this being done I want the values to be set back to $0.

Thanks!