# Search:

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

Page 1 of 6 1

## Search: Search took 0.03 seconds.

by ColdGeorge
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.

by ColdGeorge
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...

by ColdGeorge
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

by ColdGeorge
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.

5. ## Thread: Numeración por color

by ColdGeorge
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. ## Thread: Numeración por color

by ColdGeorge
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. ## Thread: Numeración por color

by ColdGeorge
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. ## Thread: Find new range

by ColdGeorge
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. ## Thread: Find new range

by ColdGeorge
Replies
8
Views
465

### Re: Find new range

Hi

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

ColdGeorge
10. ## Thread: Find new range

by ColdGeorge
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. ## Thread: Find new range

by ColdGeorge
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. ## Thread: Colour alternate rows with unknown range

by ColdGeorge
Replies
22
Views
811

### Re: Colour alternate rows with unknown range

Apple08

Give this a try
13. ## Thread: This should be an easy one, I guess

by ColdGeorge
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. ## Thread: This should be an easy one, I guess

by ColdGeorge
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. ## Thread: Ayuda con excel

by ColdGeorge
Replies
4
Views
794

### Re: Ayuda con excel

Hola LF040FCB10

ColdGeorge
16. ## Thread: El problema de los domingos

by ColdGeorge
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. ## Thread: El problema de los domingos

by ColdGeorge
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. ## Thread: El problema de los domingos

by ColdGeorge
Replies
5
Views
517

### Re: El problema de los domingos

James006

Gracias, voy a probarla, saludos.

ColdGeorge
19. ## Thread: El problema de los domingos

by ColdGeorge
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. ## Thread: Negrita de la primera palabra

by ColdGeorge
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. ## Thread: Negrita de la primera palabra

by ColdGeorge
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. ## Thread: I can't think of an easy solution

by ColdGeorge
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. ## Thread: I can't think of an easy solution

by ColdGeorge
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. ## Thread: I don't think it's possible, but...

by ColdGeorge
Replies
2
Views
145

Hi Rick

ColdGeorge
25. ## Thread: I don't think it's possible, but...

by ColdGeorge
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