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.

Lv 31,074 points

?

Favorite Answers44%
Answers142
  • 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 ago
  • Screensaver 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 ago
  • Android 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 ago
  • Android 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 ago
  • Microsoft 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 ago
  • How 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 ago
  • How 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 ago
  • Row 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 ago
  • On 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 ago
  • If 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 ago
  • Add 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 ago
  • Sub 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 ago
  • Call 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 ago
  • Use =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 ago
  • Replace 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 ago
  • How 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 ago
  • If 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 ago
  • Loop 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 ago
  • Get 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 ago
  • Excel 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