Excel Comments – Macros
Source: Excel Comments – Macros
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
‘posted by Dana DeLouis 2000-09-16
Dim MyComments As Comment
Dim lArea As Long
For Each MyComments In ActiveSheet.Comments
.Shape.TextFrame.AutoSize = True
If .Shape.Width > 300 Then
lArea = .Shape.Width * .Shape.Height
.Shape.Width = 200
‘ An adjustment factor of 1.1
‘ seems to work ok.
.Shape.Height = (lArea / 200) * 1.1
Next ‘ comment
Streisand says that on the occasions she met Jackson, he was “very sweet, very childlike.” But despite the material being painful to watch, she seems to have some sympathy for the late pop star. “His sexual needs were his sexual needs, coming from whatever childhood he has or whatever DNA he has,” she told the Times.
Bytefusion’s ntpquery seems to be incredibly old, but works. Sadly, it requires initial installation, but the application files will work fine when copied to another system.
To query the time service:
w32tm /query /status
To change time service:
w32tm /config /manualpeerlist:<IP Address or Host Name>
Tip: After changing service IP/Host, run another w32tm /query /status to confirm the settings show the new time service IP/Host.
What’s the difference between bandwidth and latency? By reading the definition of both terms above you probably already spot the difference between the two, but I’ll give you an analogy to make it easier to understand it if you are still confused. Imagine a highway with 4 lanes where the speed limit is 60 mph. Now on the Internet, bandwidth is the highway, and latency is the 60 mph speed limit. Now if you want to increase the amount of cars that travels through the highway you can add more lanes, but because the highway has too many curves, and bumps, you can’t increase the speed limit so all cars have to travel at 60 mph still. It doesn’t matter how many lanes the highway has, the cars will get to their destination at the same time regardless of the size of the highway!
Why increasing bandwidth increases download speed then you might ask, isn’t that speed? No, by increasing bandwidth you increase capacity not speed. Following the highway analogy, imagine that vehicles traveling through that highway were all trucks with house bricks for delivery. All trucks have to travel at 60 mph, but once they arrive at their destination instead of delivering 4 loads of bricks, 6 loads are delivered because 2 more lanes were added to the highway. The same thing happens when you add bandwidth to an Internet connection, the capacity is increased but the latency (speed ) stays the same.