VBA to sequentially number rows in column I want to number sequentially all cells on sheet4 starting at A2 (starts at 0) for 26000 cells in the A column  I have been trying the get the below code to work but need help.  Sheet4.Range("A2") = 0 Sheet4.Range("A2").Select Selection.DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, _   Step:=1, Stop:=26000, Trend:=False   Any advice/ fixes?
Filling cells with sequential numbers in an Excel (2003) macro I need to fill an excel column with a sequential series, in this case from -500 to 1000.  I've got a macro to do it, but it takes a lot of lines for something that seems like it should be a single function [something like FillRange(A2:A1502, -500, 1000, 1)].  But if that function exists, I can't find it.  Is the following as simple and elegant as it gets?  'Draw X axis scale Cells(1, 1).Value = "mV" Cells(2, 1).Value = -500 Cells(3, 1).Value = -499 Cells(4, 1).Value = -498  Dim selection1 As Range, selection2 As Range  Set selection1 = Sheet1.Range("A2:A4") Set selection2 = Sheet1.Range("A2:A1502")  selection1.AutoFill Destination:=selection2
What's the use/meaning of the @ character in variable names in C#? I discovered that you can start your variable name with a '@' character in C#.  In my C# project I was using a web service (I added a web reference to my project) that was written in Java. One of the interface objects defined in the WSDL had a member variable with the name "params". Obviously this is a reserved word in C# so you can't have a class with a member variable with the name "params". The proxy object that was generated contained a property that looked like this:  public ArrayList @params {     get { return this.paramsField; }     set { this.paramsField = value; } }   I searched through the VS 2008 c# documentation but couldn't find anything about it. Also searching Google didn't give me any useful answers. So what is the exact meaning or use of the '@' character in a variable/property name? How to install HPLIP on my Ubuntu to support my HP printer and/or scanner? Graph of Reputation Over Time for all linked accounts There are various articles on Hearthstone opening strategy which suggest it's a bad idea to use early-game spells and summons to damage your opponent directly, and that you should instead save them for minion removal.  An example: your starting hand contains an Elven Archer, a 1-cost 1/1 minion that does a point of damage when summoned. I've seen it advised that if going first, with that card in your hand, you should not play it, but save it for minion removal.  Another example:  Going second against a Rogue with a 2-cost 2/1 Loot Hoarder, Deathrattle: draw a card in your hand. The advice was not to play it and save the coin, because on her second turn, the Rogue can generate a dagger and kill the Hoarder.   I understand why, in most circumstances, it's better to remove a minion than damage the enemy. What's bugging me about these particular opening examples is why they're a better idea than doing nothing and ending the turn.  In both cases, you've wasted a point of mana, and the chance to take the initiatve. By having a minion on the board first, you can use the following turn to attack with that minion, possibly removing an enemy summon and leaving you clear to summon onto an empty board.   The Loot Hoarder one I find particularly puzzling. If the Rogue gets a dagger and kills it, you still have the initative, you've forced the Rogue to make what's possibly a suboptimal turn-2 play, you've done 2 damage to the Rogue and you got a card into the bargain. Sounds like a pretty good use of the coin to me.  What am I missing here? Can you catch a native exception in C# code? In C# code can you catch a native exception thrown from deep in some unmanaged library? If so do you need to do anything differently to catch it or does a standard try...catch get it? How to use the  method?  Say I want to find number of combinations I can get with $x_1+x_2+x_3+x_4=22$,  where $x_i\in\mathbb{N}$.  Is this the correct time to apply the method?  This is being repurposed in an effort to cut down on duplicates, see here:     and here: Remmina remoteapp over RDP I was wondering how to use remmina to open applications on a Windows machine over rdp using remoteapp (or seamless or whatever it's actually called).  I've already used Kim Knight's  to set up remoteapp on a Windows 7 machine and I can connect and run remote apps fine from another windows box.  Allegedly FreeRDP (which Remmina uses for its RDP Plugin) has support for remoteapp. I'm not sure how to make use of it though. I can't find any examples of people actually doing this online but there is a , from which I can infer that there is some way to run remote apps.   I've tried many combinations of settings for Client, Startup Program and Startup Path in the Advanced tab when configuring an RDP connection in Remmina, but I can't make it work. I can connect to Windows boxes with RDP just fine, just not running a remoteapp. Is  "choose from one of four options" wrong? I need backup in pressing my case that the phrase “choose from one of four options” is grammatically incorrect. Is there some resource that can prove my case, that the incorrect phrase should be replaced with one of the two following ones?        Choose one of four options   Choose from four options Cannot boot because: Kernel panic - not syncing: Attempted to kill init! This is what I've got. I cannot boot and I see the two of three little lights on the keyboard blinking all the time and the cooling is working on full power, almost.  I saw in other askubuntu topic suggestion for memory test. I did it. I didn't have any errors.  I am 99,9% sure it is not a hardware problem, because I have Windows 7 and I can boot it and it works just fine.  This problem came without any warning or something. I just turned off the laptop one day and at the other day I couldn't boot.   From recovery mode I get this: Resizing Controls in MFC I am writing a program which has two panes (via CSplitter), however I am having problems figuring out out to resize the controls in each frame. For simplicity, can someone tell me how I would do it for a basic frame with a single CEdit control?   I'm fairly sure it is to do with the CEdit::OnSize() function... But I'm not really getting anywhere...  Thanks! :) Flatten an irregular list of lists Why does speed of light have to be constant? My question is not about why speed of light has a particular constant value which has been sufficiently addressed in other questions on SE already. I want to know whether the fact that speed of light has to be constant is a consequence of other fundamental laws of Universe, or is it just a fundamental law itself.  My motivation for asking this question is thinking about Special Theory of Relativity. One way of understanding why time dilation and length contraction happen is to look at it from the perspective of constancy of speed of light. Alice who is on the moving source of light and Bob, a fixed observer see the speed of light as constant. In order for Alice to see the speed of light as a constant value, time slows down and length expands (in forward direction) thus keeping the speed constant.   In the  I'm doing, the Professor tells that this constancy of speed of light could be more generally referred to as, "Principle of wave constancy". That is, the speed of any wave is a property of the medium (and thus it remains constant). So, the speed of a wave in water, for example, remains constant even if the source of the waves (say a paddle keeps moving). Frequency and wavelength may change but the speed remains constant. In a similar fashion, light is an electromagnetic wave and thus its speed is constant. And the constant speed is defined by the medium (which happens to be vaccum i.e., no medium for light).   My questions are twofold now -    Is the above reasoning correct to explain why speed of light is constant? (i.e., thinking of it as constancy of any wave in general) Theoretically, could there be other waves that could travel through vaccum at a different speed? If yes, time dilation and length contraction will have to be different.   I'd appreciate it if the answer is kept non-technical (essential math is okay). More importantly, I request you to try and explain without using General Theory of Relativity. Because I'm thinking how the scientific understanding by 1905 had already knew that speed of light has to be constant. Pairs of numbers with a given LCM Why can't I copy a 7 GB file to an external USB HD with 120 GB free? Zsh says "no matches found" when trying to download video with youtube-dl I downloaded youtube-dl using pip on CrunchBang (a Debian Wheezy distro). When I run   youtube-dl {video URL}   I get  zsh: no matches found: {video URL}   I guess it has something to do with zsh, because I found some users on Arch forums complaining about it. When I switched to bash it worked. First Bash Script Problem When I used  pip install ipython   or  pip install "ipython[notebook]"   I get the following error:  Downloading/unpacking ipython   Downloading ipython-2.3.1-py27-none-any.whl (2.8MB): 2.8MB downloaded Installing collected packages: ipython Cleaning up... Exception: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/pip/basecommand.py", line 122, in main     status = self.run(options, args)   File "/usr/lib/python2.7/dist-packages/pip/commands/install.py", line 283, in run     requirement_set.install(install_options, global_options, root=options.root_path)   File "/usr/lib/python2.7/dist-packages/pip/req.py", line 1435, in install     requirement.install(install_options, global_options, *args, **kwargs)   File "/usr/lib/python2.7/dist-packages/pip/req.py", line 671, in install     self.move_wheel_files(self.source_dir, root=root)   File "/usr/lib/python2.7/dist-packages/pip/req.py", line 901, in move_wheel_files     pycompile=self.pycompile,   File "/usr/lib/python2.7/dist-packages/pip/wheel.py", line 206, in move_wheel_files     clobber(source, lib_dir, True)   File "/usr/lib/python2.7/dist-packages/pip/wheel.py", line 193, in clobber     os.makedirs(destsubdir)   File "/usr/lib/python2.7/os.py", line 157, in makedirs     mkdir(name, mode) OSError: [Errno 13] Permission denied: '/usr/local/lib/python2.7/dist-packages/IPython'  Storing debug log for failure in /home/username/.pip/pip.log   What does this error mean? How do I fix it? Add different materials to different parts of a mesh? How to disable Windows 10 system log In Windows 10 Resource Monitor I found that the system process is constantly writing C:\ProgramData\Microsoft\Windows\wfp\wfpdiag.etl at like 30-100KB/s. This equals 1TB write/year which is not healthy for SSD. There are other log write like C:\Windows\System32\LogFiles*** too.   Although logs is needed for diagnostics, it's better to be turned on only when problem has already occured.  Is it possible to disable as much system logs as possible to decrease garbage write amoung to SSD? How to avoid long nesting of asynchronous functions in Node.js