Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - compare sheet2.colums(1) to sheet7.colums(1) write to sheet6
Thank you! Changed up the "find last row" thing a bit and it works perfectly! i = 2 ' because I have a column heading If rMatched Is Nothing Then ' Fill the worksheet with the results If CurCell.Value <> "Column Heading" Then With Sheets("Sheet7 Label")...- BKearan
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - compare sheet2.colums(1) to sheet7.colums(1) write to sheet6
Code no longer gives error, but doesn't do anything... Sub Compare() Dim active_sheet As Worksheet Dim CurCell Dim CompCell Dim Matched As Variant Dim RealLastRow As Long Set active_sheet = ActiveSheet ' Loop through Sheet 2, column A - every cell that has something in it For Each CurCell In...- BKearan
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - compare sheet2.colums(1) to sheet7.colums(1) write to sheet6
Total Newb to VB for Applications. I've got an Excel 2007 spreadsheet that is Huge and I am manually sorting a lot of stuff. Functions have failed me. I need Code! I'm familiar with VBScript and AutoIt3. As the subject states, I need to compare Sheet2, Column 1, Cell 1 to every cell in...- BKearan
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Numbers in Admistrator's Group
Ah-ha! Thanks, Linney. In 3 out of 3 random checks, all instances were domain profiles that no longer existed in our Active Directory. :D- BKearan
- Post #4
- Forum: Microsoft: Windows
-
Numbers in Admistrator's Group
I am seeing serial numbers? in my Administrator's Group. Anyone know what or why? ie: S-1-5-21-1173626634-1814065488-618671499-11687 S-1-5-21-1173626634-1814065488-618671499-13456 S-1-5-21-1173626634-1814065488-618671499-1711 Basically, is it very safe to remove them?- BKearan
- Thread
- Replies: 3
- Forum: Microsoft: Windows
-
Maybe silly
May not be great, but I created two scripts to handle this. Remote_Reboot.vbs reads the list of computers and copies the reboot.vbs script to the computer then launches the script on the remote computer, popping up a msgbox and rebooting the computer when the msgbox goes away (either "OK" or... -
Maybe silly
How can I get a pop-up to show on a remote computer? Need to reboot a few hundred computers, showing the user a box and waiting until they click "OK" to actually reboot. -
How/Can I do this Formula in Excel 2007?
This works: =OR(ISNUMBER(SEARCH(Sheet1!B159:B192,E6))) IF you set the formula to an "array" formula by selecting the cell, press "F2" then press "ctrl+shift+enter" It tells me that, yes, at least one cell in b159 thru b192 had a value that was somewhere in the value of cell E6.- BKearan
- Post #6
- Forum: Microsoft: Office
-
How/Can I do this Formula in Excel 2007?
Doah! That should be : I want the formula to tell me that a cell in Sheet1!B159:B192 contains a part of the Value of E3 (If a part of b160 is "Jim", or the value of b168 is "Jim", the result is "YES") I would suppose that ISNUMBER is used because search returns the number of the character the...- BKearan
- Post #4
- Forum: Microsoft: Office
-
How/Can I do this Formula in Excel 2007?
From the Excel Help: Check if part of a cell matches specific text To do this task, use the IF, SEARCH and ISNUMBER functions. Note The SEARCH function is case-insensitive. Formula Description (Result) =IF(ISNUMBER(SEARCH("v",A2)),"OK", "Not OK") Checks to see if A2 contain the...- BKearan
- Post #3
- Forum: Microsoft: Office
-
How/Can I do this Formula in Excel 2007?
Trying to compare part of a cell to a column of text. =IF(ISNUMBER(SEARCH(Sheet1!B159:B192,E3)),"Yes","No") The above does not work, but I think it gets the intent across. If I replace "Sheet1!B159:B192" with "jim" and E3 contains "Jack Jimbo" I would get a "Yes". I don't want to limit the...- BKearan
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Uninstalling software using script
... you know, maybe I should have asked before, but if you go to the add/remove programs and uninstall it, does it work there? Also, try using the uninstall string from the registry in the command window - does it uninstall correctly then? -
Uninstalling software using script
Here is an example of what I've done to remove Winzip : '******************************************************************* Function RemoveWinZip(strPCName) WScript.Echo "Funtion RemoveWinZip has been called for " & strPCName LogFile.WriteLine strPCName & ",beginning Remove Process" ' Based... -
Annoying Problem
Ah... going to http://bmcserver:port/ and using the .hta as the default "home page" did not work. However, if I made a default .html page and put a link to the .hta in there, clicking on that link does launch the .hta properly and throws up a nice "Security Warning" dialogue that asks the... -
Annoying Problem
Yes, the .hta will work if they could doubleclick the .hta directly from their desktop. Unfortunatly, they will probably have to access it from a url resembling : http://bmccmserver1:someport/ Which will use IE to open it and will not just run the .hta and that is where my problem comes in. ... -
Annoying Problem
No, an Intranet site is "internal" and limited to access from our company's network, with no outside access. Secondly, the information gathered and displayed will be specific for the one computer currently accessing the page - dynamic content tailor made for the person/computer viewing the... -
Annoying Problem
Yeah, I wrote an HTA that would do it, thing is, the way its called, it opens inside a browser window, not the normal way an HTA opens itself. Users will "Link" to a URL and it will open the "Default Page" which I can make a .HTA, but it won't open it as a local html application, it will be a... -
Annoying Problem
Yes, we have BMC Configuration Manager for software deployment. Trying to get BMC's 'User self service' working, which is total and complete access OR a custom HTML page displaying only the links to software we want them to be able to "self load". We're opting for custom. The "What version... -
Annoying Problem
LOL.. thing is I AM responsible for the security on the computers that I am needing this information from to display. Basically security is THE reason I need to do this. It will be a self-service software page that will tell the end-user what version of software they have and then show them the... -
Annoying Problem
I am needing to pull information about File/Program versions from a computer opening a intranet webpage. Of course, Internet Exploder won't allow VBScript to run WMI queries. Basically I am needing to get something like : <html> <head> <SCRIPT language="vbscript" type="text/vbscript" > Sub...
