Search:

Type: Posts; User: Firefly2012; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: Concatenate a named range with text to one cell using in VBA?

    Do you have error values in your named range?

    Try changing that line to:


    temp = temp & "." & CStr(itm)
  2. Re: Concatenate a named range with text to one cell using in VBA?

    Hi

    The following should work:


    Dim vArr As Variant
    Dim itm As Variant
    Dim temp As String

    vArr = Range("NPresults").Value
  3. Replies
    9
    Views
    5,195

    Re: 3th try please help anyone?

    If you select one of these cells with the Hyperlink to the web address, and go Insert>Hyperlink via the ribbon, when the Hyperlinks dialog opens can you copy across the Address that is linked to (not...
  4. Re: Need help on getting the detailed information of a cell.

    You don't need to do anything (threads don't get marked as "SOLVED" here as they do at certain other forums). Your kind words are thanks enough :)
  5. Replies
    3
    Views
    210

    Re: VBA formula in a cell

    Try:


    ActiveCell.FormulaR1C1 = Sheets("Info").Range("E11").Value
  6. Replies
    8
    Views
    161

    Re: VBA, range() help required

    Hi

    You can probably modify Rick's code to:


    TheList = Join(Application.Transpose(Evaluate("IF(D1:D3=TRUE,TEXT(A1:A3,""dd/mm/yyyy"")&"" ""&B1:B3&"" ""&C1:C3,"""")")), vbLf)
    Do While...
  7. Replies
    9
    Views
    5,195

    Re: 3th try please help anyone?

    Opne up the VBE (Alt+F11) and go Insert>Module in the Menu bar in the VBE. Paste the following in to the module that will appear:


    Sub SaveDownHyperlink()
    Dim strFolder As String
    Dim strFiles...
  8. Replies
    3
    Views
    2,235

    Excel 2010 vs Excel 2013

    I use Excel 2010 when at home. I have access to a copy of 2013 but have not yet installed it as I haven't yet seen any reason to do so.

    For those that have used both, is Excel 2013 significantly...
  9. Replies
    1
    Views
    135

    Re: Regex dates with dots

    Hi

    Amend your FormatOutput line to:


    FormatOutput = CDate(Replace(match.Value,".","/"))
  10. Replies
    9
    Views
    5,195

    Re: 3th try please help anyone?

    Are you happy to use VBA code to do this?
  11. Replies
    6
    Views
    990

    Re: sumproduct/VLOOKUP with countif?

    Did you apply the correct sequence of arguments to DATE() as I intimated? That would result in:
    ...
  12. Replies
    6
    Views
    990

    Re: sumproduct/VLOOKUP with countif?

    Hi

    Are your dates actual discrete date values - they are not, for example, date & time (so non-whole numbers) or they are not text values instead of dates?

    Regarding your SUMPRODUCT, DATE takes...
  13. Re: Need help on getting the detailed information of a cell.

    The Formula property of the Range object will give you this eg


    MsgBox Sheets("MySheet").Range("A1").Formula
  14. Replies
    4
    Views
    136

    Re: vlookup problem

    Hi

    Change your VLOOKUP to:

    =VLOOKUP("*" & O3;Tab5!A$1:G32919;7;False)
  15. Re: Adding strings to object names through a loop with if statements based on these strings

    For your variable Variable_x you need to declare an array instead of the form:


    Dim myVariable(1 to 10) As Double

    You can refer to the comboboxes by their defined names eg:


    For x = 1 to...
  16. Replies
    4
    Views
    136

    Re: vlookup problem

    So what values would be in the Tab5!A column? Would it be 040645 or a composite value lke TA345604064599?
  17. Replies
    14
    Views
    319

    Re: MID text formula

    Can't you just make the adjustment to the first formula and then copy it down to the remaining cells?
  18. Replies
    14
    Views
    319

    Re: MID text formula

    Would you mind explaining what you mean by "throught the MID function" as it isn't immediately clear to me - do you mean you want to manipulate the section of your second formula highlighted in red? ...
  19. Re: VBA Q- Entering Formula through recorder!

    You're welcome :)
  20. Re: VBA Q- Entering Formula through recorder!

    I suspect your formula string is exceeding the formula length limit - try this instead of your current formula line of code:


    Activecell.Formula =...
  21. Re: VBA Q- Entering Formula through recorder!

    When you place in in a module, you need to 'double up' on the double quotes (that surround your country value) so that VBA does not interpret them as string terminators:


    Range("A1").Formula =...
  22. Thread: isna issue

    by Firefly2012
    Replies
    2
    Views
    237

    Re: isna issue

    You could consider doing it like this (although note there are reasons why you might not - for example if you have bazillions of these formulas to create, oh and also 'cos it's a pig to debug):
    ...
  23. Replies
    1
    Views
    161

    Re: Simple Excel formula Help.....

    Hi

    Here's one way using SUMIFS - you create a lookup table with your possible grade/error combinations and resulting points. The 0 points don't need an entry in the table.
    <b>Excel...
  24. Replies
    3
    Views
    314

    Re: Turn on Automatic Calculation

    In the workbook's ThisWorkbook module, you could place the following:


    Private Sub Workbook_Open()
    Application.Calculation = xlCalculationAutomatic
    End Sub

    Macros would need to be enabled...
  25. Replies
    5
    Views
    6,294

    Re: vba extract text before dot

    Hi

    One option:


    Dim myString As String

    myString = Split("AAA.xls",".")(0)

    MsgBox myString
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4