Programming

mstsc from hyperlink
try this c:\windows\system32\mstsc.exe /v :nas nas=servername --- frmsrcurl: http://msgroups.net/microsoft.public.excel.programming/mstsc-from-hyperlink ... 12 Apr 2010 02:41

If the cell is empty, copy the value from a specific cell.
Hi there, How do I write a macro that will check the cells to see if they are empty. If the cell J3 is empty, if it will copy the content from J2 onto J3. Do the same for J4, J5... J8. Thanks, Aline ... 12 Apr 2010 09:13

How to open a specific worksheet via code from workbook_open
I have a combobox which is populated with all the worksheets within the workbook. The controlsource of the combobox is linked to cell c5 on Sheet1 My question is how do i make the Excel workbook open at the worksheet which is detailed within the combobox linked cell. I've been previously using in the Workbook_O... 12 Apr 2010 10:19

Can't break out of code help!
Somehow one of my VBAs got called and I can't get out if it. Esc only calls up the Dialog box that allows me to End/Continue/Debug, End does nothing, Debug stops but I still can't CANCEL it. Any suggestions? I am stuck otherwise and will lose a lot of work... ... 12 Apr 2010 03:46

$29.00 FAKE ID FAKE IDENTIFICATION CARDS, FAKE ID'S & NOVELTY ID CARDS
YOU CAN GET A GREAT FAKE ID AT REALLY AFFORDABLE PRICE AT: http://www.peiid.com fake id, fake identification, fake ids, fake id's, fake identity, new identity, newids fake hologram id, fake driver license, fake new identity, fake driving license, canada fake id, usa fake id uk fake id, uk fake driving license... 11 Apr 2010 20:09

Variant Array Copy, Array row contains Object
Hi All, For the first time I had a need to put an object inside a two dimension variant array. The proc below was for some initial testing. I had to code an object test at the line marked with 1. I was surprised that the 'copy' at line 2. worked. Can you tell me why? Thanks. Neal ... 13 Apr 2010 11:43

Sort issue Sort Of
I have cells A1, B1, C1, D1 and E1 each contains a name. What I need to do is, if the contents of say cell C1 is deleted the I need the contents of cells D1 and E1 to move up. It is critical that that the name remain in the same order (there by precluding a normal sort). So this would have to work regardless of... 12 Apr 2010 21:28

sheet2 = sheet1
I want to create a sheet2 and, between cells A1 and P200, any time that sheet1 has something in one of those cells, whatever it might be, I want sheet2 to simply reference that result. If sheet1 is empty in that cell, then I want sheet2 to also be the same. It seems that the easiest way to do this would be to ma... 12 Apr 2010 17:03

Compile error. Need Help with this UDF !!!!!!!!!!!!!!!
I wrote a function that worked fine before and now all of a sudden I am getting a "Compile error: Expected array." The problem seem to be with the line "startRow(marketNAME)" especially "startRow" I can't figure out the problem. Please HELP. Sub getSTARTEND_ROWS() Dim c As Range, startRow As Long, endRow As ... 11 Apr 2010 21:15

Select Case
Hello Group, I have a select case that is not working as I expected, Delta1ToSP = -3.38629648094637E-02 or -.0338: Select Case Delta1ToSP Case -0.02 To -0.05 ' This is where I expected the stop Stop Case -0.050001 To -0.1 Stop Case -0.10001 To -1 Stop Case 0.02 To 0.05 ... 11 Apr 2010 21:15