Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.34 seconds; generated 15 minute(s) ago.

  1. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    In that case can you please post some accurate samples of your data. Explaining exactly what you want for each.
  2. Replies
    7
    Views
    76

    Re: Vlookup with 2 conditions

    Glad to help & thanks for the feedback
  3. Replies
    3
    Views
    57

    Re: Multiple subs in VBA Code ?

    Try it like
    If Not Intersect(Target, Range("AA3")) Is Nothing Then
    Me.Rows("45:161").Hidden = False

    Select Case Range("AA3").Value
    Case 1
    ...
  4. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    Yes because if the cell is blank you cant get the 4the character from the right ;)

    How about
    Sub Infine()
    Dim Cl As Range

    For Each Cl In Range("C2", Range("C" & Rows.Count).End(xlUp))...
  5. Re: Search for text, insert a row above when found, insert text in that new cell, then repeat. How????

    How about

    Sub hikerguy()
    With Range("A1", Range("A" & Rows.Count).End(xlUp))
    .Replace "!", "=xxx", xlWhole, , , , False, False
    .SpecialCells(xlFormulas,...
  6. Re: VBA Search for any of three items, return whole row or rows of matching data.

    Glad to help & thanks for the feedback
  7. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    Do you have any blank cells in col C?
    Also do any cells in col C anything other than numbers?
  8. Replies
    7
    Views
    76

    Re: Vlookup with 2 conditions

    Ok, in that case use
    =INDEX($D$3:$D$2500,MATCH(G3&"|G",INDEX($A$3:$A$2500&"|"&$C$3:$C$2500,0),0))
  9. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    Not sure how you get that error on that line, but are your numbers in col C?
  10. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    What was the error number & message?
    Also when you click debug, what line was highlighted?
  11. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    To colour columns A:D use
    Sub Infine()
    Dim Cl As Range

    For Each Cl In Range("C2", Range("C" & Rows.Count).End(xlUp))
    Intersect(Cl.EntireRow, Range("A:D")).Interior.ColorIndex =...
  12. Replies
    4
    Views
    44

    Re: If value is 12 then fill range 1-12 etc..

    OK, any problems adjusting it, just shout.
  13. Replies
    7
    Views
    76

    Re: Vlookup with 2 conditions

    I'm sorry but I don't understand what you mean.
  14. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    Not quite sure what you mean by colour the entire column, so this will add background fill to each cell
    Sub Infine()
    Dim Cl As Range

    For Each Cl In Range("C2", Range("C" &...
  15. Replies
    7
    Views
    76

    Re: Vlookup with 2 conditions

    How about
    =INDEX($D$3:$D$13,MATCH(G3&"|G",INDEX($A$3:$A$13&"|"&$C$3:$C$13,0),0))
  16. Replies
    3
    Views
    32

    Re: return certain value

    Ok :)
  17. Replies
    7
    Views
    32

    Re: INDEX/MATCH with Return Numbers Only

    You're welcome & thanks for the feedback
  18. Replies
    7
    Views
    32

    Re: INDEX/MATCH with Return Numbers Only

    The *1 should get rid of the space (assuming it's a normal space)
  19. Replies
    11
    Views
    77

    Re: VBA Macro Problem

    Cross posted https://www.excelforum.com/excel-programming-vba-macros/1293254-excel-macro-to-rename-workbook-tabs-does-not-work.html#post5211349

    While we do not prohibit Cross-Posting on this site,...
  20. Replies
    3
    Views
    32

    Re: return certain value

    How about
    =LOOKUP(D1,{0,0.95,0.98,1,1.2,2},{"",1,2,3,4,5})
  21. Re: IF or IF(And) formula for 3 logical tests - Excel 2016

    How about something like
    =IF(C1>=20,"Suitcase",IF(C1>=15,"Steak knives",""))
  22. Replies
    7
    Views
    32

    Re: INDEX/MATCH with Return Numbers Only

    In that case try
    =IFERROR(RIGHT(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),7)*1,"")
    This will convert the text into a number. If you want to keep it as text, delete...
  23. Replies
    7
    Views
    32

    Re: INDEX/MATCH with Return Numbers Only

    Will all the returns end in a 7 digit number?
  24. Replies
    4
    Views
    44

    Re: If value is 12 then fill range 1-12 etc..

    How about
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) = "A1" Then
    If Target.Value > Range("C" &...
  25. Replies
    11
    Views
    77

    Re: VBA Macro Problem

    In that case try
    Sub Andy0311()
    Dim Ws As Worksheet

    For Each Ws In Worksheets
    Ws.Name = Ws.Range("B5").Value
    Next Ws
    End Sub

    This assumes that the names are all...
Results 1 to 25 of 149
Page 1 of 6 1 2 3 4