|
Prueba esto:
Sub Valores()
FILAS = 10
COLUMNAS = 4
For I = 1 To FILAS
For J = 1 To COLUMNAS
Cells(I, J).Select
fila = ActiveCell.Row
col = ActiveCell.Column
If ActiveCell.Interior.ColorIndex = 6 Then
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Next J
Next I
End Sub
|
