Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

?
How to write Active Directory Queries with Regex?
I'm trying to make a query that returns all servers that end in ##. I don't want to have to write a query for each number. How do I write a query that allows for Regex? It's safe to assume there will not be any servers with ## except at the end of the name string. The regex would be something like ^\d{2}.
I have Powershell, as well as the AD GUI. I've searched and it looks like Regex can be used in queries, I just haven't found out how.
1 AnswerProgramming & Design9 years agoScreensaver software that supports dual monitors?
I am looking for screensaver software that supports dual monitor usage. The operating systems will be Windows XP and Windows 7. I have tried AnyLogo Screensaver (poor quality) and Axialis (good quality, no dual monitor support). Does anyone know of a good product? Thanks
Software9 years agoAndroid IRC client w/ Server Pass option?
I am trying to find a good IRC client for my phone. I have played with a couple, but none seem to give me the ability to include a server password. I have a bouncer set up, but I cannot use it from the my phone without the ability to include the server name, port, and server password. I would prefer a free client if possible. Thanks.
I originally had this posted in computer software, but was told I would be more likely to get a response here.
2 AnswersCell Phones & Plans9 years agoAndroid IRC client w/ Server Pass option?
I am trying to find a good IRC client for my phone. I have played with a couple, but none seem to give me the ability to include a server password. I have a bouncer set up, but I cannot use it from the my phone without the ability to include the server name, port, and server password. I would prefer a free client if possible. Thanks.
1 AnswerSoftware9 years agoMicrosoft Word 2010 Move Image?
I am trying to turn off the "Move object with text" option, but the check box, along with everything else in the position tab, has been disabled. Is there another way to turn off the move object with text? I have tried going to the ribbon and clicking the Picture Tools Format tab -> Position -> More Layout Options and right clicking the image and selecting size and position. Both give me the aforementioned results.
Thanks in advanced. 10 points to the first useful answer.
2 AnswersSoftware9 years agoHow to add parameterized functions to a PowerShell object?
I have a group of functions in a module. How do I create an object and add those functions to that object?
1 AnswerProgramming & Design9 years agoHow to add controls to a group in Infopath?
I am trying to make an InfoPath form that hides a block of controls if a specific selection on a drop down list is made. How do I group these controls so I can make one rule instead of making a separate rule for each of them?
1 AnswerProgramming & Design10 years agoRow selected Expected Array error VBA?
I am trying to create a macro in Excel VBA. I want to delete every row after the first row. I have tried a few different ways, but I always get an Expected Array compiler error. I have tried using both a range and a loop that would go one row at a time. My code has looked like the following:
dim rng as string
dim prodRows as int
prodRows = Application.WorksheetFunction.CountA(Range("B:B"))
rng = "2:" & trim(str(prodRows))
Rows(rng).select
Selection.delete Shift:=xlUp
'attempt two
dim dlt as intFor k = 2 To prodRows
dlt = k
rows(dlt).delete Shift:=xlUp
Next k
Both receive the compiler error. What am I doing wrong? Is there another way to delete all rows after the first?
3 AnswersProgramming & Design10 years agoOn Error Goto err executes err every time Excel VBA?
The following code is inside a for loop. I have tried having errmsg directly after the On Error. When I do that the error code always executes. I have also tried putting errmsg outside of the loop. In this instance, it will cycle through the loop and catch the errors properly, but after the loop is finished it will still execute the errmsg code.
'code
On Error GoTo errmsg
tierMonth = Month(CDate(Range(rngDate)))'try this. if no error execute this and execute code below
errmsg: 'if error go here. execute this code and end sub
MsgBox ("Please make cell " & rngDate & " a date only then rerun macro.")
Sheets("Claims Tier5").Select
Range(rngDate).Select
Exit Sub
3 AnswersProgramming & Design10 years agoIf last month Then Excel VBA macro?
I am trying to write a macro that says If date is any day of last month Then execute code. Is there a function that I can compare date and it will tell me if last month = true? If not, is there a way to find the first and last day of last month? I would then be able to say if date is greater than first day AND less than last day Then execute.
2 AnswersProgramming & Design10 years agoAdd correct icon to cell depending on value Excel?
I have a spreadsheet that compares actual to approved. The If statement is If(A1<(A1*B1*90%),"Green",If(A1<B1,"Yellow", "Red")). For now, I have another column in the row displaying the result of this If statement. I need to add the correct conditional formatting icon to cell A1, as well as the value that is already in A1. I will need to do this for every row of the filtered set (size will change).
1 AnswerSoftware10 years agoSub or Function not Defined VBA Compiler error?
When I try to run this code, a compiler error states that the sub or function is not defined. Sub Busn_Prod() is the highlighted line when it errors. How do I fix this? Thanks.
Sub Busn_Prod()
'
' Busn_Prod Macro
'
Dim rows As Integer
Dim closer As String
Dim pcode As String
Dim toCopy As String
Dim prodRows As Integer
Dim prodStart As String
Sheets("Joy's Sheet").Select
rows = Application.WorksheetFunction.CountA(Range("B:B")) 'counts rows on joy's sheet
Dim i As Integer
For i = 1 To rows
'columns with closer and product codes
closer = "T" & LTrim(Str(i))
pcode = "M" & LTrim(Str(i))
If Not Range(pcode).Text Like InStr(0, "77216") And Not Range(pcode).Text Like InStr(0, "1569") Then
If Range(closer).Text Like InStr(1, ignoreCase("closer")) Then
toCopy = "A" & LTrim(Str(i)) & ":AK" & LTrim(Str(i)) 'selects row to copy
Sheets("Busn - Prod").Select
prodRows = Application.WorksheetFunction.CountA(Range("B:B")) 'counts rows
prodStart = "A" & LTrim(Str(prodRows + 1)) 'first empty row
prodStart = Range(toCopy).Text 'copies copied row into first empty row
End If
End If
Next i
End Sub
1 AnswerProgramming & Design10 years agoCall a user defined function in another UDF Excel VBA?
I need to call Sub FindNew() in another function that is part of the same workbook. What is the proper way to call it?
3 AnswersProgramming & Design10 years agoUse =Today() function in Excel VBA If statement?
If Sheets("Source Data").Range(src).Text = Sheets("Static").Range(stat).Text And Sheets("Source Data").Range(sDateCheck) <= Today()-Weekday(Today(),3)+4) Then
What is the proper way to use the Today() function in this If statement? It does not compile as is.
1 AnswerProgramming & Design10 years agoReplace hard code with variable in Excel If statement using VBA?
Hard coded, the VBA code looks like this:
Range(formulaString).Select
ActiveCell.FormulaR1C1 = _
"=IF(Data!R[-58]C1=""yes"", ""duplicate"" ,Data!R[-58]C[+1])"
Range(rangeStr).Select
I want to change to the following:
"=IF(Data!R[variable]C1=""yes"", ""duplicate"", Data!R[variable]C[+1])"
I tried making variable = "-" <rim(str(58)), but that still creates an error.
What am I doing wrong?
1 AnswerProgramming & Design10 years agoHow to find fill color of another cell in Excel?
How do I find the fill color of another cell in Excel? My If statement in pseudo-code looks like the following: A7=If(B3 <> red, B3, not red). I would like A7 to display the value of B3 if B3 has a fill color of red, otherwise I would like A7 to display "not red". Thanks
2 AnswersSoftware10 years agoIf statement only true once in For loop VBA?
I am writing a macro that checks for duplicate IDs on separate sheets in a VB workbook. The loop will loop through perfectly and find the first duplicate. After the first duplicate, the If statement will always evaluate to false, even when there is a duplicate. What is causing this? My code is below.
Sub FindNew()
'
' FindNew Macro
'
Dim numRowsThis As Integer
Dim numRowsData As Integer
Dim dataCell As String
Dim thisCell As String
'number of rows in each sheet are listed in these cells
numRowsThis = Sheet5.Range("B2").Value
numRowsData = Sheet5.Range("B1").Value
Dim i As Integer
Dim j As Integer
'loops through sheet1
For i = 1 To numRowsData
'gets cell location
dataCell = "A" & LTrim(Str(i))
'loops through sheet 2
For j = 4 To numRowsThis
'gets cell location
thisCell = "B" & LTrim(Str(j))
'compares cell from each sheet
If Sheet3.Range(dataCell).Value = Sheet5.Range(thisCell).Value Then
MsgBox (dataCell & " " & thisCell)
End If
Next
Next
'
End Sub
1 AnswerProgramming & Design10 years agoLoop automatically kicks out if If statement is true VBA?
I am working on an Excel macro that should find any cells with duplicate IDs and highlight them in red. For some reason, when it finds a duplicate it will exit out of the loop. It cycles through fine if there are not any duplicates. My code is below.
Sub FindNew()
'
' FindNew Macro
'
Dim numRowsThis As Integer
Dim numRowsData As Integer
Dim dataCell As String
Dim thisCell As String
numRowsThis = Sheet5.Cells(2, 2).Value
numRowsData = Sheet5.Cells(1, 2).Value
Dim i As Integer
Dim j As Integer
For i = 1 To numRowsData
dataCell = "A" & LTrim(Str(i))
For j = 4 To numRowsThis
thisCell = "B" & LTrim(Str(j))
If Sheet3.Range(dataCell).Value = Sheet5.Range(thisCell).Value Then
Range(dataCell).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range(thisCell).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End If
Next
Next
'
End Sub
1 AnswerProgramming & Design10 years agoGet value from cell in Excel VBA?
I need to make a loop that goes for n iterations. n is located in cell B2. How do I get the value in cell B2 for my VBA macro?
2 AnswersSoftware10 years agoExcel VBA column selected?
I am new to VBA and Excel. I am trying to make a loop that will cycle through all of the rows in a column then move on to the next column and do the same thing. For the rows I believe it should look something like this:
Do Until IsEmpty(cells(iRow, COLUMN SELECTED )
What do I put in the column selected? I can not put a static column name because it will be changing every time I finish going through the rows and start a new column.
2 AnswersProgramming & Design10 years ago