Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    6
    Views
    246

    Re: This question may be easy to answer

    mikerickson

    Thanks, your code works just perfect.


    BrandonBerner

    Your formula, works great too, thanks.
  2. Replies
    6
    Views
    246

    Re: This question may be easy to answer

    Hi mikerickson

    I am very sorry, but I'm afraid I made a big mistake due to my poor English. I want to copy A1 value to all cells of column A. Only if column B cells have a value. In another words...
  3. Replies
    6
    Views
    246

    Re: This question may be easy to answer

    Hi mikerickson

    I'll give it a try and I'll let yoo know, thanks.

    ColdGeorge
  4. Replies
    6
    Views
    246

    This question may be easy to answer

    Hi all

    I just want to copy a cell (A1) value down to A2. Only if B2 has a value. And so forth, copy A2 to A3 if B3 has a value.

    Thanks in advance, ColdGeorge
  5. Replies
    5
    Views
    636

    Re: Numeración por color

    Hola James006

    Gracias, con tu ayuda pude alcanzar mi objetivo, y aprender algo nuevo, saludos.

    ColdGeorge
  6. Replies
    5
    Views
    636

    Re: Numeración por color

    Hola amigos

    Estoy experimentando con este código:



    Dim cell As Range
    For Each cell In Sheets("literaturapuntual").Range("B3:B44")
    If cell.Font.Color = vbRed Then
    cell.Offset(0, -1).Value...
  7. Replies
    5
    Views
    636

    Numeración por color

    Buenos días

    En el rango B3:B43 tengo una lista de nombres, algunos de ellos están en rojo (font, color).

    Solicito ayuda para crear en la columna A la numeración necesaria (1,2, 3, etc.) para...
  8. Replies
    8
    Views
    465

    Re: Find new range

    Hi

    Post #1 says "In range A3:S33, I use this code to highlight a row.....However, every now and then I add records and range may vary. How should I edit code in order to adjust range? I mean auto...
  9. Replies
    8
    Views
    465

    Re: Find new range

    Hi

    I really don't think your code do what I need, thanks.

    ColdGeorge
  10. Replies
    8
    Views
    465

    Re: Find new range

    Hi

    Here's the complete scrip


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim row As Long, column As Long

    row = ActiveCell.row
    column = ActiveCell.column
  11. Replies
    8
    Views
    465

    Find new range

    Hi all

    In range A3:S33, I use this code to highlight a row.



    Dim row As Long, column As Long

    row = ActiveCell.row
    column = ActiveCell.column
  12. Re: Colour alternate rows with unknown range

    Apple08

    Give this a try
  13. Replies
    3
    Views
    181

    Re: This should be an easy one, I guess

    Thanks for answering Robby19, unfortunately, it does not work, when I enter same values your formula still says no (not the same).

    ColdGeorge
  14. Replies
    3
    Views
    181

    This should be an easy one, I guess

    Hi all

    I am looking for an easy -and working- formula to tell me when A1, B1 and C1 values are the same, after a search for help on the Internet I feel very confused, thanks in advance for your...
  15. Replies
    4
    Views
    794

    Re: Ayuda con excel

    Hola LF040FCB10

    ¿Has probado con filtros?

    ColdGeorge
  16. Replies
    5
    Views
    517

    Re: El problema de los domingos

    Hola

    johnmpl, se ve interesante la opción que ofreces, vamos a probarlo a te notifico los resultados, gracias.

    ColdGeorge
  17. Replies
    5
    Views
    517

    Re: El problema de los domingos

    James006

    Tu fórmula funcionó como se esperaba, gracias y buen día.

    ColdGeorge
  18. Replies
    5
    Views
    517

    Re: El problema de los domingos

    James006

    Gracias, voy a probarla, saludos.

    ColdGeorge
  19. Replies
    5
    Views
    517

    El problema de los domingos

    Hola amigos

    ¿Es posible conocer cuántos domingos (o cualquier otro día) hay en un mes cualquiera si en una celda tengo 07/05/2017?

    Gracias de antemano, ColdGeorge
  20. Replies
    3
    Views
    423

    Re: Negrita de la primera palabra

    Hola James006
    Después de probarlo, esta versión me acomoda mejor, gracias.


    Dim celda As Range
    For Each celda In Selection
    celda.Characters(1, 1).Font.Bold = True
    Next
  21. Replies
    3
    Views
    423

    Negrita de la primera palabra

    Hola amigos

    Solicito de su ayuda una vez más, ¿cómo puedo hacer que la primera letra de la primera palabra de una celda sea convertida en negrita? el rango puede ser muy grande, gracias de...
  22. Replies
    2
    Views
    136

    Re: I can't think of an easy solution

    Hi Instantaneo

    Thanks for your assistance, it works just fine.

    ColdGeorge
  23. Replies
    2
    Views
    136

    I can't think of an easy solution

    Hi all

    In column A is the Plan, column B is the Actual, A2 shows first Plan quantity, B2 shows first Actual quantity, and so forth.

    In column C, I want to show difference between B2-A2, in...
  24. Replies
    2
    Views
    145

    Re: I don't think it's possible, but...

    Hi Rick

    Thanks for your response.

    ColdGeorge
  25. Replies
    2
    Views
    145

    I don't think it's possible, but...

    Hi all

    Is it possible to autocomplete a cell with data in a range? for instance, autocomplete, let's say in B1 names starting with A having values in A1:A20, apple, adam, ant, etc.

    ColdGeorge
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4